Archives of the TeradataForum
Message Posted: Fri, 31 Mar 2006 @ 10:41:04 GMT
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.
.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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|