DB2 Errors and DataStage Message ID's

[JPalatianos]

Hi,
We are attempting to decipher the different errors that we recieve on our DB2 connector stage and have a reject link. We were thinking we can demote certain warnings (i.e. Dup key) while aborting the job when a more severe errors are encountered. We tested some of this out but it appears that DataStage cans all the warnings into one message id (IIS-CONN-DB2-00016) and does not allow us to distinguish between the various DB2 error codes.

We receieve the same message ID (IIS-CONN-DB2-00016) for both dup -key errors as well as incorrect datetime value and even other DB2 errors.

Does anyone have a work-around for this?

Thanks - - John