ERROR_SQLCODE( )

SIGNED INTEGER with the value of the SQLCODE of the error that invoked the error handler.

This function can be called anywhere within a TRY statement, and it returns the SQLCODE anywhere in the error handler.

• TRY statement
• BEGIN statement
• ERROR_LINE function [Miscellaneous]
• ERROR_MESSAGE function [Miscellaneous]
• ERROR_PROCEDURE function [function type]
• ERROR_SQLSTATE function [Miscellaneous]
• ERROR_STACK_TRACE function [Miscellaneous]
• STACK_TRACE function [Miscellaneous]
• sa_error_stack_trace system procedure
• sa_stack_trace system procedure
• Nested compound statements and exception handlers
• Example: Creating an error logging procedure that can be called by an exception handler

The statement SELECT ERROR_SQLSTATE( ), ERROR_SQLCODE( );, when executed within a handler that was invoked by a division by zero error, returns the following result:

'22012', -628