Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Nov 2007 @ 14:48:29 GMT


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


Subj:   Re: FastLoad Record Delimiter
 
From:   Geoffrey Rommel

  How can I change the default record delimiter(newline) to another character?  


I believe the question about which OS you are using was about the client; i.e., which OS FastLoad is running on, not Teradata.

Assuming that you are running FastLoad on *nix or Linux, there is no way to change the default record delimiter. The notion that newline ('\n' or x'0A') is the end of a record is built into the OS at a very low level. For instance, getline() depends on this assumption.

So we're back to the old question: what problem are you trying to solve? If the incoming records have differing numbers of fields, you could run them through a preprocessing routine (perl, awk, DataStage, whatever) to make sure that every record has the proper number of fields before handing it to FastLoad.



     
  <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