Archives of the TeradataForum
Message Posted: Fri, 17 Oct 2014 @ 14:17:16 GMT
Subj: | | Re: FastExport error while using BTEQ .IMPORT command |
|
From: | | Anderson, Dirk |
Check your syntax with the Fast Export manual. Also, you don't need a REPEAT or INSERT command like BTEQ. Here is an example from the Teradata
manual:
.IMPORT INFILE /home/fexpuser/tests/data1 FORMAT BINARY Layout layl;
Here is an example of a layout from the manual:
.LAYOUT DATAIN_LAYOUT INDICATORS;
.FIELD c1c1 1 INTEGER;
.FIELD c2 5 CHAR(20);
Thanks.
Dirk Anderson
|