I went through resolved topic How to Ouput Reject Records from DB2 Connector to Flat File.
I could be missing something but, I'm unable captute actual records except error code and/or error text either dataset ot file. I have RCP enabled in my job and in administartor.
Problem:
1. I have 10 records coming from source, 5 of them got inserted and 5 of them rejected, and I could see the count as 5 on reject link as per performance statistics, but unable to see the actual records in the dataset ot file. Also I don't see the 5 record count in the performance statistics in the link coming to db2 connector, although records got inserted.
2. Aslo 5 inserted records commit to db even though property in db2 connector set to autocommit off.
Any input on this greatly appreciated. Thanks.
How to Ouput Reject Records from DB2 Connector
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try capturing the reject records into a sequential file, and have a reject link on that stage too (to a separate text file).
Hitting the end of your data will cause DataStage to generate a COMMIT irrespective of the number of records sent to the database.
Hitting the end of your data will cause DataStage to generate a COMMIT irrespective of the number of records sent to the database.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,
Thanks for the reply.
I tried having a reject link to the sequential file I'm trying to capture the reject records in to. I was unable the see the records except the error code which I have checked in the db2 connector stage. If I don't check either error code or error text, my view data is greyed out.
I want records with the data and the error code in to text file or data set. Any way would work for me.
Thanks for the reply.
I tried having a reject link to the sequential file I'm trying to capture the reject records in to. I was unable the see the records except the error code which I have checked in the db2 connector stage. If I don't check either error code or error text, my view data is greyed out.
I want records with the data and the error code in to text file or data set. Any way would work for me.
vishal
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India