Archives of the TeradataForum

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

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

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