Archives of the TeradataForum

Message Posted: Thu, 29 Mar 2001 @ 13:40:34 GMT

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

Frank,

I have used the following to export the data from a Fastload ET table to a flat file. You should be able to modify it for a Multiload ET table.

     .SET RECORDMODE ON
     .EXPORT DATA FILE = export file name

     SELECT ErrorCode      (char(05))
           ,ErrorFieldname (char(30))
           ,DataParcel     (byte(xx))
       FROM FASTLOAD_ERR1
     ;

      xx = number of bytes in the source record

Hope this helps.

Respectfully,

David M. Stanek
DMS Consulting Services, Inc.

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