Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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 ";";

     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;

Kind Regards

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023