Stored procedure return status results

A status result set consists of a single row which contains a single value—a return status.

All stored procedures that run on a Adaptive Server return a status number. Stored procedures usually return 0 to indicate normal completion. For a list of Adaptive Server default return status numbers, see the return reference page in the Adaptive Server Enterprise Reference Manual.

Because return status numbers are a feature of stored procedures, only an RPC command or a language command containing an execute statement generates a return status.