Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Mar 2003 @ 16:17:12 GMT


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


Subj:   Re: Fastload Query
 
From:   Michael Larkins

Hi MAB:

Loading a delimited file is one of the newer capabilities of Fastload. To accomplish this do the following:

1. DEFINE statement - all fields are VARCHAR with the longest possible length of characters in each (between delimiters)

2. use the SET RECORD command to define record as VARTEXT followed by your delimiter in quotes

That should pretty much take care of it for you. If you need an example, the manual has one and additional verbage on using this technique. Please be aware that Fastload will not run as fast using delimited files as it does with raw data because it must look at each character position to determine if it is a data character or a delimiter.

Good luck, Mike



     
  <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