To abort a job for reject records

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

To abort a job for reject records

Post by mydsworld »

I want to abort a job when there is any record in reject link associated with Transformer. I can do it by making that reject link, an 'otherwise' link and then specifying 'Abort after rows' parameter.But how to do similar thing (abort a job) with reject link.

Thanks.
bikan
Premium Member
Premium Member
Posts: 128
Joined: Thu Jun 08, 2006 5:27 am

Post by bikan »

Just want to know..why you want reject link out from transformer.. as you have mentioned you can do it without reject link.
DSDexter
Participant
Posts: 94
Joined: Wed Jul 11, 2007 9:36 pm
Location: Pune,India

Re: To abort a job for reject records

Post by DSDexter »

Please specify more details. After how many rejects do you want to abort the job?
Thanks
DSDexter
suresh.narasimha
Premium Member
Premium Member
Posts: 81
Joined: Mon Nov 21, 2005 4:17 am
Location: Sydney, Australia
Contact:

To abort a job for reject records

Post by suresh.narasimha »

You need to specify 1 for ' abort after rows '
SURESH NARASIMHA
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Post by mydsworld »

Setting 'Abort after rows' to 1 applies if I am using a normal link in Transformer with otherwise condition in constraint. But reject link won't come in constraint.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

then create another link to a peek stage , and condition otherwise.
abort job if there is one row in this link
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Post by mydsworld »

Without using an 'Otherwise' link in Transformer, I would like to abort a job whenever there is certain records in a Reject Link.
Is that possible ?
Jasti
Participant
Posts: 44
Joined: Sat Apr 14, 2007 6:34 am
Location: Hyderabad, India

Post by Jasti »

I guess..You can connect that reject link to another transformer and in that you will be able to specify the contraints to abort the job..
Thanks,
Mohan.A.Jasti.
Post Reply