Error Handling for Batch processor for Discard situation during Load
Is it possible to control the discard situation in a way that other warnings
with return code 4 are tolerated and simultaneously the processing of
batch processor is not if we get a discard situation with return code 4?
Currently the batch processor processing depends on the Return Code(RC) from the utility execution.
It will not look for the actual reason behind the RC, this includes DISCARD processing or any other
processing for DB2 LOAD which results in RC 4.
We need DISCARDS 1 parm to be added to IBM LOAD statement to generate RC > 4 from DB2 when
there are any discarded rows.
The batch processor will stop the processing if a RC > 4 is received from DB2.
Populating DISCARDS parm in IBM Load statements can be achieved by customizing the utility model.
Process is given below:
1. Go to RC/Migrator -> 0 - Profile -> 6 - Utility Model Services
2. Enter U for updating the model
3. Enter E to Edit/Customize the LOAD utility
4. Add DISCARDS 1 clause immediately after the DISCARDDDN clause of LOAD DATA INDDN ... statement and save.
The further analysis using the updated utility model will generate the LOAD cards with DISCARDS clause.