Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Fload problem: a discrepency between read and expected
 
From:   Apoorva Kahale

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