Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 25 Sep 2009 @ 16:00:31 GMT


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


Subj:   Bteq Import and data mismatch
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, September 25, 2009 11:41 -->

I keep getting data type mismatch while I am trying to import a fixed length text file using Bteq Import. I did verify the length defined but Import still does not work. Wondering if I am missing some thing. Host is windows network attached.

     .IMPORT DATA FILE =MYFILE.TXT
     .REPEAT *
     USING
              FIELD1           (CHAR(10)),
              FIELD2           (CHAR(10)),
              FIELD3           (CHAR(10))

     INSERT INTO MYTABLE
     (FIELD1,FIELD2,FIELD3)
     VALUES
     (
     TRIM(:FIELD1))
     ,(TRIM(:FIELD1))
     ,(TRIM(:FIELD1))
     )
     ;

     .IF ERRORCODE > 0 THEN .QUIT ERRORCODE;

Any suggestion is appreciated.



     
  <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