Archives of the TeradataForum
Message Posted: Fri, 25 Sep 2009 @ 16:00:31 GMT
| 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
INSERT INTO MYTABLE
.IF ERRORCODE > 0 THEN .QUIT ERRORCODE;
Any suggestion is appreciated.