CALLED STORED PROC FROM BTEQ SCRIPT

Database
Junior Supporter

CALLED STORED PROC FROM BTEQ SCRIPT

env - TD-EXPRESS - V15.10

I'm calling a stored proc. from a BTEQ script. I'm attempting to determine how to test the success / failure of the

stored proc. within the script. Currently I'm testing the value of ERRORLEVEL however I'm not entirely sure if

ERRORLEVEL is indicating a failed SQL stmt. within the proc. or it is indicating the success / failure of just getting

to the stored proc. itself.  Have done some testing and I'm seeing some mixed results on this.

 

Anyone have some thoughts on this?

 

thanks


Accepted Solutions
Junior Supporter

Re: CALLED STORED PROC FROM BTEQ SCRIPT

I'VE REWORKED SOME OF MY TESTS AND NOW HAVE MY ANSWER.....

1 ACCEPTED SOLUTION
1 REPLY
Junior Supporter

Re: CALLED STORED PROC FROM BTEQ SCRIPT

I'VE REWORKED SOME OF MY TESTS AND NOW HAVE MY ANSWER.....