Return Values from Routine Activity

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
justlrng
Participant
Posts: 30
Joined: Thu Oct 16, 2003 1:17 pm

Return Values from Routine Activity

Post by justlrng »

Hi,

I am attempting to call a routine using a Routine Activity in a sequence. Based on what the return value is I decide on which path to follow. However, although the routine is being called, it always returns the error

DW03100sLoadBackOut3..JobControl (@routCheckinsCertStaffRptAssoc): Routine DSU.CheckFileExistsNr did not finish OK, return code = 'Y'.

"Y" is the expected value and I've set up under the "Triggers" tab, the Expression type of "ReturnValue - (Conditional)" with the Expression being "= "Y" ".

Is there something obvious I'm missing or I'm I just setting this up incorrectly?

Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sounds like you are using the new feature to 'automatically handle jobs that fail'. Routines that return a non-zero value are considered to have failed when that option is turned on.

Two things to try:

1) turn off the option
2) Add an 'otherwise' trigger so that it thinks you are handling the error and therefore it doesn't have to.
-craig

"You can never have too many knives" -- Logan Nine Fingers
justlrng
Participant
Posts: 30
Joined: Thu Oct 16, 2003 1:17 pm

Post by justlrng »

Thank you.

Turning off the option of "Automatically handle...." does the trick. I never would have thought of that. :D
Post Reply