abort the Job
Moderators: chulett, rschirm, roy
abort the Job
I want to make job aborted when there is no records to update in the target table, can anyone tell me how can we achieve this?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why abort? Why not prevent the job from running in the first place?
Either way is possible. Run a command that checks the existence of the files and sets its exit status how you wish. Then test that.
If you're using a before-job subroutine, set ErrorCode to a non-zero value to abort the job.
Either way is possible. Run a command that checks the existence of the files and sets its exit status how you wish. Then test that.
If you're using a before-job subroutine, set ErrorCode to a non-zero value to abort the job.
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.
Thanks to everyone for all your replies.
Ray: I could not know whether there are records in the target table to update. because i get the rows from source table and update to target table. I know while updating only.
Craig: Yes craig, If there are no matching records in the target table. we get rows in the source.
Pandeesh: I believe we can use that function in Transformer only.
Ray: I could not know whether there are records in the target table to update. because i get the rows from source table and update to target table. I know while updating only.
Craig: Yes craig, If there are no matching records in the target table. we get rows in the source.
Pandeesh: I believe we can use that function in Transformer only.