Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Apr 2008 @ 16:59:01 GMT


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


Subj:   Fast Export is skipping spaces at the end of
 
From:   Anomy Anom

<-- Anonymously Posted: Fri, 18 Apr 2008 10:17 -->

When a FASTExport is run against a table with a char(30) address attribute, the (presumed) spaces at the end of the field are not written to the field in the FastEx-output file.

I have been assured that the file used to load this data had a fixed length format with spaces padding each field to reach a common length of 30.

When the postion function is used to identify the first occurrence of consecutive spaces (2 of 'em), a value of zero is returned, suggesting that the position function is not recognizing consecutive spaces.

Any thoughts how to force the FastEx to build the field in the out-file with the padded spaces at the end.

(Currently, the field in the out-file has a VARCHAR quality to it, no spaces at the end.)

Please dock my account for a virtual cold one this Friday afternoon.


Thanks



     
  <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: 27 Dec 2016