Capturing rejects from database
Moderators: chulett, rschirm, roy
Capturing rejects from database
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.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn