Sequecer abort issue

prasson_ibm · Post by **prasson_ibm** » Thu Mar 05, 2009 5:03 am

Hi all,
I have a sequence, in which i m calling 5 jobs.
In first job data is extracted from oracle db (oracle stage) and loaded into db2table(db2 api stage).If zero rows are transferred,then i want this job to be abort,so that my sequencer is aborted........please adivce me how to implement this..??

Thanks

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 05, 2009 6:06 am

search for getlinkinfo

bart12872 · Post by **bart12872** » Thu Mar 05, 2009 6:57 am

you can use a lookup. Force a reference with one line in the principal flux. And if there is not line from the reference 'Abort'

ray.wurlod · Post by **ray.wurlod** » Thu Mar 05, 2009 3:33 pm

You don't ever want to abort if you can avoid it. Create a simple server job that retrieves the row and loads the same into its user status area then check this in the job sequence to make the decision about whether to process the remaining jobs or merely to bypass them (maybe logging a message and/or sending an email).