Reject Handling with DB2 Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
yammanur.dwhcareer
Participant
Posts: 7
Joined: Sun Apr 10, 2011 11:30 am
Location: Delhi

Reject Handling with DB2 Stage

Post by yammanur.dwhcareer »

Hi All!

My job design looks like the below.

Dataset->T/R -->Db2-->(Rejectlink)Dataset.

Write Mode-->Insert
Table action-->Append
For the testing purpose we are processing some duplicate records and trying to collect the rejected records which are not able to insert in the DB2 table.
RCP is enabled because of using the same template we are populating more entities.So, we are not in the position to change our 'Write Mode' also.

The problem is we are not able to collect the rejected records from DB2 and the job getting aborted due to the unique key violation(dup records).
Please help us in data rejection.

Thanks in Advance...... :?:
Top
nayanpatra
Participant
Posts: 41
Joined: Sat Jun 06, 2009 11:13 pm
Location: Kolkata

Post by nayanpatra »

Try using an exception table in a DB2 connector stage. It will automatically route the duplicate primary keys to the exception table.
Nayan
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”