Information générale
Catégorie:
Codage, syntaxe et commandes
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement