Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

Hi,

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;
     .logoff

In the data file i have the following text

     7839

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.


Thanks

Dhanraj P



     
  <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: 27 Dec 2016