I have a parallel job to load the data into a table in db2 from the sequential file.
some records are getting rejected from the source sequential file itself .My requirement is along with the rejected records
the decription for the rejected rows like( Delimiter for field "SpecialComments" not found; input: {E x t e r n a l}, at offset: 758)
should also be there in the rejected file. can anyone help me in this regard
Here is my job design
Seq file(source file) ------> Transforer ............> DB2 Table
Seq file(source file)..............> Seqfile (Reject file)
Output
The reject file should contain the rejected records along with the description of the rejection
Can anyone help me out on this problem...
Any solution for this problem is really appreciated.............
Thanks
kj
Capture Rejected rows along with its description in rej file
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your reject link needs to have sqlcode on it, then you need to look this up against a table of error codes. This could be a sparse lookup back to the DB2 error codes table (for example).
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: