Export a variable length record

Tools

Export a variable length record

I need to export data from an sql to a variable length text record. I have been trying various things with bteq and fastexport and have not been successful. Has anyone done this? I need the output file to be something like this:

99999|9|999|abcdefg
99|999|9999|abc
999999||9|abcdefghijk

2 REPLIES
Enthusiast

Re: Export a variable length record

Hi
Just on similar lines, I need the ASCII '1F' (Non-printable control character' to be used as the delimiter. I have tried this using the BTEQ EXPORT but have not been successful.
Can any body suggest how can this character included as a delimiter?
Thanks!

Re: Export a variable length record

Sunopsis:

Problem :
(SnpsSqlUnload) : can not font ? such : (thai language)

Who! :
This Solution : ?