Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 10:41:04 GMT

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

Sidharth,

We usually do the following:

When you have a fastload failing with records in Errorfile 1, rather than deciphering the hexadecimal dataparcel you can export the errorfile into a flat file on the MVS.

Create an output file with a recordlength (input file + 38) - this will allow the errortype and errorfieldname to be included in the output.

For example

     .SET RECORDMODE ON
     .EXPORT DATA DDNAME=OUTDATA;
     SELECT * FROM errorfile1;
     .EXPORT RESET

This will return the records that are in error, and then allow you to see only the records that have failed (much better than searching through the whole input file).

You may find this useful.

Thanks

Martin

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