Archives of the TeradataForum

Message Posted: Fri, 20 Jun 2008 @ 16:39:07 GMT

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

Hi,

This is my bteq snippet:

     .import data file=in_condition.out
     .repeat 2
     using dno (char(3));
     sel * from department where deptno = :dno;

and my in_condition.out file contains:

     $>more in_condition.out
     100300

But when I execute the bteq script,I am getting the following error:

     using dno (char(3));

       *** Starting Row 0 at Fri Jun 20 02:16:05 2008

       *** Growing Buffer to 12592

       *** 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 Fri Jun 20 02:16:05 2008

       *** Total elapsed time was 1 second.

     +---------+---------+---------+---------+---------+---------+---------+----

     sel * from department where deptno = :dno;

       *** Failure 3857 Cannot use value (or macro parameter) to match 'dno'.
                      Statement# 1, Info =0

       *** Total elapsed time was 1 second.

Please advice.

Thanks

Sridhar.S

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