Archives of the TeradataForum
Message Posted: Wed, 04 Dec 2002 @ 18:17:09 GMT
| Subj: || || Re: Fast Export - Blank line |
| From: || || Dwight Etheridge |
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.