Checking particular condition in Routine activity(Sequencer)

kaps · Post by **kaps** » Tue Oct 31, 2006 6:05 pm

Hi

Requirement is to check for header, trailer formats, check the counts in the trailer of incoming file and if everything is correct then run the job or don't run the job.

I have a shell script to do all of the above and I am calling this script from a routine. I have to check for 3 files so I have 3 routines with difft file name to check in the same job. I am exiting with "Invalid Header Record" when it happens which I could see in the log.

I have a custom condition in Triggers of all the three routines which checks the condition and sends the error mail and stops the job...

rtn.$ReturnValue= "Invalid Header Record"

But it's not stopping the job. It shows as successfully completed.
Can anyone tell me what am I missing ?

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Oct 31, 2006 6:47 pm

You've marked this as resolved. What were you missing?

kaps · Post by **kaps** » Wed Nov 01, 2006 10:09 am

I returned number from the shell script isntead of string.

rtn.$ReturnValue= "Invalid Header Record" (did not work)

rtn.$ReturnValue= 1 (worked)