Archives of the TeradataForum

Message Posted: Thu, 12 Dec 2002 @ 20:10:32 GMT

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

I have following fastexport script file but it give me error(copied below), can someone help me with this?

.LOGTABLE databaseName.LOG_TESTT2;

.LOGON fff/name,pwd;

DATABASE dababasename;

.BEGIN EXPORT;
.LAYOUT intLoad;
.FIELD loadNum * char(9);
.IMPORT INFILE
D:\Datawarehouses\fastExport\testttt.txt
LAYOUT intLoad;
.EXPORT OUTFILE
D:\Datawarehouses\fastExport\data91.txt
 mlscript
D:\Datawarehouses\fastExport\data91script.sql;

 SELECT

cust_no, cust_name FROM atable WHERE NLOAD =
cast(:loadNum as integer);
.END EXPORT;
.LOGOFF;

/* accesws module error '16' received during 'read'
operation  on record number '0:) unexpected data format'*/
/* record '1' of file 'd:\.. is too short by '9' bytes.*/

Thanks,

JoAnn

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