Archives of the TeradataForum

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

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

<-- 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>>