I am not a DB2 person so I'm sure this question is quite trivial, but I'm using the following command:

EXPORT TO pathname.txt OF DEL

along with a Select statement that gives me a file like:

1,2,3,4
a,b,c,d
3,2,d,3

It puts commas between the fields. I need tabs or blanks like:

1 2 3 4
a b c d
3 2 d 3

Is there an argument or something that I need to supply to get tab delimited vs comma delimited?

Thanks.

EXPORT TO ... OF DEL MODIFIED BY COLDEL0x09 SELECT ...

"COLDEL0x09" specifies column (field) delimiter as the character having hex code of 0x09, which is a tab symbol.

Nick

THANK YOU! That worked perfect!