Returning value from routine - error handling in sequence

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
DSUser2000
Participant
Posts: 42
Joined: Tue Oct 20, 2009 8:36 am

Returning value from routine - error handling in sequence

Post by DSUser2000 »

What is the correct way to return the value from a routine in a Datastage sequence? If I just return it via the return value, I have to disable "Automatically handle activities that fail" and "Log warnings after activites that finish with status other than OK" in the sequence. Otherwise the sequence stops because the return value is seen as "Not OK". However, without these options, there's no correct error handling with the other jobs (parallel ones) in the sequence. Is there any solution?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yes, and it has been discussed here quite a bit and there was even a webinar on the subject. Searching for "automatically handle" should turn those conversations up.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply