Archives of the TeradataForum

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

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

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>>