Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 21:49:18 GMT


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


Subj:   Fastload - Set Record Vartext
 
From:   Joseph Massena

How do I set the format of the input data as ",". The txt file contains data separated by comma but it also contains double quotes for each data value of each column.

SET RECORD VARTEXT ","; This statement does work but the records in the loaded table comes with double-quotes as explained.

     0008 SET RECORD VARTEXT """,""";

     **** 14:38:11 Now set to read 'Variable-Length Text' records
     **** 14:38:11 Delimiter character is set to '"'
     **** 14:38:11 Command completed successfully

Any help greatly appreciated.


Joseph



     
  <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