Hi Guys,
Is there any option for the Datastage job to Fail if the Before Job-Routine
Fails ?
Regards
Sreenivasulu
Option for Job to "Fail" if the "Before Job-R
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Sreenivasulu,
The before-job routine returns an error-code, if this is non-zero the job will fail.
The before-job routine returns an error-code, if this is non-zero the job will fail.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Ray,
I may not be clear in my question.
The before job routine is calling a shell script. The shell script in turn calls a stored procedure.
The paths are parameterized and when the shell script does not find the
path of the storedprocedure it does not generate the log and the
datstage job gets executed. But i do not want the datstage job to get executed if the before-job routine fails.
Regards
Sreenivauslu
I may not be clear in my question.
The before job routine is calling a shell script. The shell script in turn calls a stored procedure.
The paths are parameterized and when the shell script does not find the
path of the storedprocedure it does not generate the log and the
datstage job gets executed. But i do not want the datstage job to get executed if the before-job routine fails.
Regards
Sreenivauslu
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Have the shell script exit with a status code other than 0.
You can detect this with the fourth argument of DSExecute, and set the ErrorCode argument accordingly.
You can detect this with the fourth argument of DSExecute, and set the ErrorCode argument accordingly.
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.