Page 1 of 1
Capturing rejects from database
Posted: Tue Apr 28, 2009 11:38 am
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.
Posted: Tue Apr 28, 2009 7:53 pm
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.