Hi
Can anyone tell me how do i capture format rejects or dropped records in a server job.
I am not able to see any "reject link" option here. My job structure is:
Seq File - > Transformer - > sql server
I just want to capture all records with wrong schema at seq file stage and those records who drop at transformer due to any reason. There was a reject link in parallel jobs. But i cannot find it here.
thanx,
Rohit
how to capture bad format rejects
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Hi Rohit,
There is an option avialable in the server jobs too. It is Link variable. Check for this in the tranformer by right clicking,you will find an option Linkvariables-->Output & Constant.Check with it.
You can catch you rejects based your specification.
There is an option avialable in the server jobs too. It is Link variable. Check for this in the tranformer by right clicking,you will find an option Linkvariables-->Output & Constant.Check with it.
You can catch you rejects based your specification.
just want to capture all records with wrong schema at seq file stage and those records who drop at transformer due to any reason. There was a reject link in parallel jobs. But i cannot find it here.
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not totally true, but close enough. The way to do it is to read the file as containing a single VarChar column, parse it in a Transformer stage, and make the accept/reject decision while parsing.
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.