Capturing Reject records
Moderators: chulett, rschirm, roy
Capturing Reject records
I have a job design like this :
Seq File -> Transformer -> DB2 API
While loading DB2 table, some records are getting dropped in DB2 API stage. I need to capture those Reject records in a file (not from Director) Now, DB2 API stage doesn't allow to have a Reject link.
When I use ODBC Ent stage instead of DB1 API and set Write Method = Upsert, I can have a Reject link, but getting the following error :
Sequential_File_20: Error when checking operator: Could not find input field "sqlcode". [api/interface_rep.C:2168]
As ODBC Ent stage adds a field 'sqlcode' in the rejected data set which is not coming from input.
Please advise.
Seq File -> Transformer -> DB2 API
While loading DB2 table, some records are getting dropped in DB2 API stage. I need to capture those Reject records in a file (not from Director) Now, DB2 API stage doesn't allow to have a Reject link.
When I use ODBC Ent stage instead of DB1 API and set Write Method = Upsert, I can have a Reject link, but getting the following error :
Sequential_File_20: Error when checking operator: Could not find input field "sqlcode". [api/interface_rep.C:2168]
As ODBC Ent stage adds a field 'sqlcode' in the rejected data set which is not coming from input.
Please advise.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Look carefully. The Sequential File stage is the one that has generated the error message. This stage type does not generate sqlcode - after all, it doesn't use SQL.
My guess is that you have tried to propagate sqlcode column through your job design. Get rid of it. If you create a proper reject link ("Convert to Reject") as output from your database stage, then sqlcode will appear there automatically.
My guess is that you have tried to propagate sqlcode column through your job design. Get rid of it. If you create a proper reject link ("Convert to Reject") as output from your database stage, then sqlcode will appear there automatically.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I created the Reject link from ODBC Ent to Seq File (directly without any Transformer etc).It is giving the error :
Sequential_File_20: Error when checking operator: Could not find input field "sqlcode". [api/interface_rep.C:2168]
When I place Peek stage instead of Seq File, the job works. But I would like to use Seq File to capture the reject records.
Please advise.
Sequential_File_20: Error when checking operator: Could not find input field "sqlcode". [api/interface_rep.C:2168]
When I place Peek stage instead of Seq File, the job works. But I would like to use Seq File to capture the reject records.
Please advise.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The reject link should not have any connection to the Transformer stage. It is an output from the ODBC Enterprise stage. Its link type must be Reject (painted in long dashes in the design area).
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.
Ray,
Believe me, I am directly taking the Reject link from target ODBC Ent to Seq File (with no Transformer in between). It does give that error. This was my original design.
Now, if I replace Seq File (at the other end of Reject link) with Peek, it works. So, any idea why I am not able to use Seq file to capture the rejected records.
Believe me, I am directly taking the Reject link from target ODBC Ent to Seq File (with no Transformer in between). It does give that error. This was my original design.
Now, if I replace Seq File (at the other end of Reject link) with Peek, it works. So, any idea why I am not able to use Seq file to capture the rejected records.
-
- Participant
- Posts: 1
- Joined: Wed Nov 14, 2007 3:08 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We're in the parallel job world here!devanars wrote:I dont think so seqential file will work for rejected link. It will work fine if you use only Peak or Hash file.
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.