DSXchange

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?

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.