DB2 Errors and DataStage Message ID's
Posted: Wed Jan 15, 2014 10:24 am
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
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