This should be a simple one...

I am having trouble creating a text file with the full field width using the COPY TO command.
I have a simple table... f1 C(8), f2 C(20)
When I copy the data to a text file (COPY thisfile TO test.dat DELIMITED WITH "") the field widths of each row are as wide as the data for that row, I want the trailing spaces but I DO NOT want the quotation marks wrapped around each character field.

Eg.
Rec F1 F2
1 ABC DESCRIPTION REC1
2 DEF ANOTHER DESC.

Result Required...
ABC ,DESCRIPTION REC1
DEF ,ANOTHER DESC.

-- 8 --,------ 20 ----------



I suppose I could use FCREATE() but I would have thought COPY TO could do it.