Archives of the TeradataForum

Message Posted: Tue, 22 Mar 2005 @ 17:26:12 GMT

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

I have writen a test fload but I get a discrepency in the number of bytes read and the number of bytes expected. I have attached the sample code, please help me solve this problem

     sessions 2;
     errlimit 25;
     ..logon demotDAT/dbc,dbc;
     drop table iw_demo.employee_fload;
     create table iw_demo.employee_fload(
      Num INTEGER  FORMAT '999' NOT NULL,
      Name CHAR(6)
      )
      UNIQUE PRIMARY INDEX(Num);

     begin loading iw_demo.employee_fload
       errorfiles iw_demo.error_1,
           iw_demo.error_2;
     set record unformatted;

     DEFINE
      Num  (char(2)),
      Name  (char(2))

     file=c:\practice\employee_1.txt;
     ..show;
     insert into iw_demo.employee_fload
     values (
      :Num,
      :Name
      )
     ;
     end loading;
     ..logoff;

employee_1.txt contains

     367abcdef
     589efghij

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