Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Dec 2013 @ 09:37:35 GMT


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


Subj:   FastLoad script with delimited input file
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, December 11, 2013 01:03 -->

Hi All,

Could someone please advise the syntax for loading a ';' delimited file into Teradata?

Is below correct?

     Logon teradata/username,password,;

     database db_name;

     set record format  VARTEXT ";";

     DEFINE
     field1   type,
     field2   type,
     field3   type,
     field4   type,
     field5   type

     FILE = input_file.txt;


     begin loading target_table_name errorfiles err_1, err_2; insert into target_table_name ( :field1, :field2, :field3, :field4, :field5, );

     end loading;
     logoff;

Kind Regards



     
  <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