Archives of the TeradataForum

Message Posted: Wed, 04 Dec 2002 @ 18:17:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

TARUN,

I've experienced the same thing. The final result of your field concatenation is VARCHAR. Fexp writes it out with a leading 2 byte binary length value. When that binary value is just right, it produces the random line feeds that are screwing up your export file. So, you need to do a final cast into a char() like so:

 (c1 || c2 || c3 ) (char(n))  -- when n is big enough to cover the longest row.

This will eliminate the 2 byte binary length value, and make a fixed width file.

	<Prev	Next>		<<First	<Prev	Next>	Last>>