Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Getting error in import and repeat commands in bteq
 
From:   SATHYANARAYANAN, SRIDHAR

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