Re: MODE and FORMAT - TD Utilities.

Hi Raj,

again, those "unidentified things" are two bytes indicating the length of the resulting VarChar. This is a well-known problem with FExp, there's no built-in way to get delimited data without additional steps, usually there's an OUTMOD (or Unix script) simply stripping of the first two bytes.

For a small result set you can utilize to BTEQ (which never returns trailing blanks in REORT mode) or better switch to TPT.

Re: MODE and FORMAT - TD Utilities.

Thanks dnoeth !!! For time being I would go with stripping of the first two bytes using simple unix command. I will explore TPT later.

But, I've read in the manual stating that,

The default FORMAT is in a UNIX or LAN environment. FASTLOAD format has a two-byte integer, followed by the data, followed by an end-of-record marker. It is called because the data is exported in a format ready for FASTLOAD.

So I've tried Fast export with format fastload using that output file I've passed that as input file to fastload script. I'm getting error like Unexpected data format. Will it be a one another drawback ? Find the below scripts i've used.