How to capture return code from a script and fail the Sequen

theone · Post by **theone** » Fri Jul 02, 2010 8:13 am

I have BTeq script in a routine activity sequence, based on the return value how can I fail the Sequence?

chulett · Post by **chulett** » Fri Jul 02, 2010 8:18 am

This might help get you started, that or a search for "bteq". For 'Sequence failure' a link to a Terminator stage is generallly what is needed but there are multiple ways to skin that cat.

theone · Post by **theone** » Fri Jul 02, 2010 1:45 pm

I checked the form and found the syntax

"Call DSExecute('UNIX',Script A,Output,Error)"

I am using following :

Call DSU.ExecSH("/export/ds/xyz/abctest.sh", ErrCode)
If ErrCode <> 0
Then Call DSLogFatal("failed", rtnName)

am i doing the right way?

chulett · Post by **chulett** » Fri Jul 02, 2010 2:41 pm

Where are you doing this?

theone · Post by **theone** » Fri Jul 02, 2010 5:10 pm

I did that in a custom defined server routine and calling it as before job sub routine

chulett · Post by **chulett** » Fri Jul 02, 2010 9:10 pm

Before what job? I thought this was all happening in a Sequence job via the Routine Activity stage. Sounds like you are making this more difficult (and more hidden) than it really needs to be.