While loading data from flat file to Teradata table using MLOAD,few records has bad data.Due to these records MLOAD got failed and this data hasn't been captured in ET tables. So I have used "DISPLAY ERRORS NOSTOP" command to make sure that MLOAD get completes without fail.But I want to write such bad records into a file for furthur investigation.
Can someone help me in acheiving this task please?
Re: CAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD?
The first item of importance is to not that the DISPLAY ERRORS and NOSTOP options only work with VARTEXT records. It will not work with the binary formats.
Next, the DISPLAY ERRORS option will indicate to MultiLoad that the rows in error should be written to the standard error output (stderr). You can easily redirect stderr to any file of your choice on the MultiLoad command line.
That should write sysout to its normal destination, but will write ALL the errors - error messages and error records to syserr. You should be able to sed the file to redirect/ remove error messages if you need to.