Hi ,
I am inserting records into three tables in db2. I a am using API stages. How can i capture the rejected records(error records) by the database
Thanks in Advance
M
How to Capture the error records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada
This is applicable only for Server jobs. But what about in PX? In PX we cannot get the (DB2Link) REJECTED option. So then how will we capture the rejected records which are not inserted into the db?kumar_s wrote:In the transformer prior to the DB2 API stage, on the rejectred link, in the constraints, use LinkVariable --> Outputs --> (DB2Link) REJECTED.
Thanks & Regards,
Rony
Rony
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada
DB2 API stage does not support any reject links.
If using DB2 Enterprise stage is an option for you, then you can use the upsert option with a reject link to catch the rejected records.
Otherwise you have to parse the log for 'rejected' entries and abort the job. Then data verification should be done manually.
If using DB2 Enterprise stage is an option for you, then you can use the upsert option with a reject link to catch the rejected records.
Otherwise you have to parse the log for 'rejected' entries and abort the job. Then data verification should be done manually.