Reusing the Discard File

File-AID enables you to reuse the discard file as input to the load process when the load job was completed normally, but rows were discarded.

Discarded records are written to the discard file when you specify YES in the Save Discarded Rows field on the SQL Insert Processing Options screen. The discard file is modeled after the extract file with similar attributes and contents, such as header, create, and data records. The discard data records are those that have been discarded because of RI constraints, duplicate rows, etc.

To reuse the discard file as input for the interactive phase of the Load function, you must step through the interactive phase specifying the name of the discard file in the File Name field on the Load Specifications screen.