Vinod,
From your original description of your objective I would say you do NOT want SDF format. SDF format would make each output field the same size as its *defined* source field and you say you want a single space separating each field *only* for the length of the content (not definition) of the field.
I guess an alternative way to describe SDF is that there will be *NO* spaces between any two fields which have one of those fields completely filling the defined length while other fields may have several blanks between them when the fields are SHORTER than the defined length.
Cheers,
Jim N.
>>>>I want SDF Format with spaces, I have tried copy to command all variations, export command
>>>
>>>What I've done for your situation when nothing seems to work is to create an intermediary table in which you reformat the fields to exactly the way (length, etc) you want, and then copy...
>>
>>
>>I guess, better than that is :- List to file command, which transfers the output to a text file, What do you Suggest ??
>
>That could work...it depends what you're trying to do...
Précédent
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