Capturing rejects from database

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
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Capturing rejects from database

Post by mydsworld »

I need to populate (insert,upsert) some DB2 table.But DB2 API stage doesn't have the option of having Reject links. So, can that be done by ODBC Ent stage. If yes, how.
Top
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:
Contact vmcburney

Post by vmcburney »

You can do it with the DB2 enterprise stage which will also be faster than the API stage. Have a look at Retrieve sql codes on a failed upsert. It works well on DB2 and poorly on Oracle.
Top
Post Reply

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