|  |  | Archives of the TeradataForumMessage 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 
 
 |  |