Archives of the TeradataForum

Message Posted: Tue, 26 Oct 1999 @ 15:05:48 GMT

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

Kenneth,

Try this BTEQ script to trap error records to a file.

     .logon dbc/userid,passwd
     .SET RECORDMODE ON
     .EXPORT DATA FILE=C:\data\errorrecords.txt
     SELECT Errorcode , Errorfieldname , DATAPARCEL FROM
     databasename.err1tablename;
     .quit

Thanks

Kranti K. Penmethsa

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