Archives of the TeradataForum

Message Posted: Fri, 02 Feb 2007 @ 11:52:35 GMT

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

Apologies, meant to include my script

     Logon User,pwd;
     DROP TABLE DB.Table1;
     DROP TABLE DB.Table1_TEMP1;
     DROP TABLE DB.Table1_ERROR_2;
     create table DB.Table1
     (stf_dvn_nm varchar(50)
     ,stf_sub_dvn_nm varchar(50)
     ...
     ,cur_emp char(01)
     ,asg_sta varchar(50)
     )
     unique primary index(stf_mbs_no)
     ;
     SET RECORD VARTEXT ",";
     define
      division (varchar(50))
     ,sub_division (varchar(50))
     ......
     ,curr_emp_flag (varchar(01))
     ,assign_status (varchar(50))
     FILE=C:\inputfile.txt;
     SHOW;
     BEGIN LOADING DB.Table1
     ErrorFiles DB.Table1_TEMP1, DB.Table1_ERROR_2;
     INSERT INTO DB.Table1
     (:division
     ,:sub_division
     .....
     ,:curr_emp_flag
     ,:assign_status)
     ;
     END LOADING;
     LOGOFF;

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