#!/bin/bash
 
        OUTPUT=$(isql -Usa -Ppassword -DNP_DB << EOF
        exec testing
        exit;
        EOF)
        echo output $OUTPUT
        echo last command status : $?
        if [ "$OUTPUT" != 0 ]
        then
            echo "error return from SP"
            exit
        else
            echo "SP return 0"
        fi

create proc testing
as
return 1

[tecnomen]##/export/home/xyz> ./callgSPFromScript_new.sh
output
last command status : 0
error return from SP
[tecnomen]##/export/home/xyz>

#!/bin/bash
`isql -Usa -Ppassword -DNP_DB << EOF
declare @returnValue int
exec @returnValue = testing
select ReturnValue=@returnValue
go
EOF`
echo $ReturnValue
echo last command status : $?
if [ "$OUTPUT" != 0 ]
then
echo "error return from SP"
exit
else
echo "SP return 0"
fi