Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Aug 2005 @ 15:31:57 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023