Hi,
I have Server job with the following flow.
Seq. File Stage --------------->Transformer---------------->Dataset
Please let me know how can i capture the reject records from Seq. File Stage.
In parallel job i can have a reject link coming out of Seq. File stage but since this is a server job its not possible.
Please provide me a logic where i can capture all the reject records which does not meet the metadata of my Seq. File Stage.
Thanks
Capture Reject Records
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 46
- Joined: Tue Mar 20, 2007 3:30 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can't.
Server edition does not have the concept of data types.
You will need to perform any necessary validation testing in the Transformer stage, and create an output link from that which can handle any rows that are not passed to the third stage.
Server jobs do not have the concept of Data Sets, and therefore don't have a Data Set stage.
Server edition does not have the concept of data types.
You will need to perform any necessary validation testing in the Transformer stage, and create an output link from that which can handle any rows that are not passed to the third stage.
Server jobs do not have the concept of Data Sets, and therefore don't have a Data Set stage.
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.
-
- Premium Member
- Posts: 46
- Joined: Tue Mar 20, 2007 3:30 am
- Location: India
Thanks Ray,
My problem is that if say there are 10,000 records in the source file with pipe as delimiter then if there is are few records where pipe is a part of value its causing the whole job to abort.
and it becomes very difficult to identify those few culprit records.
Isn't there a way to separate those records and process the remaining clean records.
My problem is that if say there are 10,000 records in the source file with pipe as delimiter then if there is are few records where pipe is a part of value its causing the whole job to abort.
and it becomes very difficult to identify those few culprit records.
Isn't there a way to separate those records and process the remaining clean records.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
As Ray said, you can read the complete line in one column and try to identify those records in transformer and if It doesn't fit your requirement send it to other link as a rejected records.bi_fujitsu wrote:Thanks Ray,
My problem is that if say there are 10,000 records in the source file with pipe as delimiter then if there is are few records where pipe is a part of value its causing the whole job to abort.
and it becomes very difficult to identify those few culprit records.
Isn't there a way to separate those records and process the remaining clean records.
Regards,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA