Micheal,
As far as I know the sdf clause is the only way to write the full (fixed) field with.
Copy To test.dat Type Sdf
Leo
>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.