DSXchange

I am trying to capture the records rejected while loading a db2 table due to a unique key violation error .
The DB2 Connector stage is rejecting the records when array size and record size are set to 1, but the rejected records only has error_code and error_text , it doesn't show the rejected record data .
As suggested in some posts I tried to write the rejects to a dataset also , but it also has only the error codes .
Is there any option to see the rejected records data without enabling the RCP (runtime column propagation ) .
Datastage version is 8.5

Thanks
Arif

Try to put your reject link through a transform stage, you can use this stage later if you need to abort your process if you have any rejected records. Add a Peek stage to the tranform stage make sure that all the columns appears in the input of the peek stage. You may have this already but check that you have the reject option set to 'yes'.

Thanks
Arif

There is no reject option in DB2 connector , you have to select the reject link and in the column definition all it shows are the error codes no input column , so the rejected records only have the error code but not the rejected data .

Putting the reject link through transform doesnt make any difference , the rejected records still doesnt show the data that was rejected .

Thanks

RCP works, why not use it?

RCP is disables in our environment , I was checking if there was any other workaround .

Thanks