parameter for abort after n rows

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please try to maintain a professional standard of written English at DSXchange. It helps those whose first language is not English. In particular avoid SMS-style abbreviations (DSXchange is not a portable telephony device, but a forum where professionals exchange ideas).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
shaimil
Charter Member
Charter Member
Posts: 37
Joined: Fri Feb 28, 2003 5:37 am
Location: UK

Post by shaimil »

If you're not concerned about processing all the data or the dataset is relatively small, this could be achieved by using an after job routine to check the link count on the reject row.
dsusr
Premium Member
Premium Member
Posts: 104
Joined: Sat Sep 03, 2005 11:30 pm

Re: parameter for abort after n rows

Post by dsusr »

Use the transformer options Abort after rows by using the Following Logic.

Use a stage variable to count the number of rejected records. Create a link in the transformer with the Constraint that the Rejected Stage Variable Count > Job Parameter for the Abort.

For the same link use the option Abort on Rows = 1
Post Reply