DSXchange

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

search for getlinkinfo

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'

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).