Archives of the TeradataForum

Message Posted: Fri, 31 Oct 2003 @ 18:47:43 GMT

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

I have a fastexport script like this....

.logtable db_dev.utillog;

.LOGON abc/uid, pwd;

.BEGIN EXPORT
SESSIONS 20;

.LAYOUT UsingData;
 .FIELD scandesc * char(10);

.IMPORT INFILE C:\fast\INPUTDAT.TXT
 LAYOUT UsingData;

.EXPORT OUTFILE bascii1;

select * from  views.table1 where scandesc=:scandesc;

.END EXPORT ;

.LOGOFF ;

What should be the format of the data in the inputdat.txt ...i tried various formats but not running...

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