DSXchange

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

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.

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?

Where are you doing this?

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

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.