INF: Checking Results of Stored Procedures with RAISERROR

ID Number: Q67933

1.10 1.11 4.20

OS/2

Summary:

One way to check the results of a stored procedure is to use RAISERROR

within the stored procedure to set the global variable @@ERROR. Then,

when you return to the first procedure, you can check for the value of

@@ERROR.

Another way to check the results of a stored procedure is to determine

the number of open transactions by referencing the global variable

@@TRANCOUNT.

Additional reference words: 1.10 1.1 1.11 4.20 4.2 stored procedures