|
|
Archives of the TeradataForum
Message Posted: Thu, 11 Aug 2005 @ 15:31:57 GMT
Subj: | | Re: Fixed width files from FastExport |
|
From: | | Victor Sokovin |
| here is the output; I get junk characters as well. the file layout has 31 attributes; I am getting only the ones with valid values. | |
| Do I have to explicitly pad each null-valued attribute with "blanks" to generate a fixed width file? | |
Yep, all the formatting is manual work. You could use such tools as casting to CHAR(n) (automatic right padding) or COALESCE, or perhaps the
combination of both.
Have fun!
Victor
| |