Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 08:33:59 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Error while importing a file in bteq
From:   Dhanraj Palani


I am getting an error while importing a file in bteq Following is the piece of code which i have written

     .logon test/test,test
     .IMPORT data file=emps;
     .repeat *
     using pempno (varchar(4))
     update test.emp set sal=10000
     where empno = :pempno;

In the data file i have the following text


Following is the error which i am getting

     *** Growing Buffer to 18763
     *** Error: Import data size does not agree with byte length.
                The cause may be:
                    1) IMPORT DATA vs. IMPORT REPORT
                    2) incorrect incoming data
                    3) import file has reached end-of-file.
     *** Warning: Out of data.
     *** Finished at Wed May 25 11:42:45 2005

Can anyone please let me know what exactly is the problem.


Dhanraj P

  <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