RESIGNAL
Valid in: DBProc, TblProc
The RESIGNAL statement passes a handled condition form an inner handler to an outer handler for that condition. If no signal value is given, the condition that caused the resignalling handler to execute is implicit. If a condition handler causes an error or warning, it is as if an implicit RESIGNAL statement had executed.
RESIGNAL must occur inside a handler action, and typically need not specify a condition.
The RESIGNAL statement has the following format:
RESIGNAL [signal_value]
signal_value
Specifies a condition name or a state or error value. The condition name can be a user-defined condition or a predefined condition. The state or error value can be:
SQLSTATE [VALUE] string_literal
Example: SQLSTATE '22012'
DBMSERROR [VALUE] integer_constant | string_literal
The integer value is what would be retrieved by the predefined variable IIERRORNUMBER.
Examples: DBMSERROR 4111 or DBMSERROR 'E_US100F'
Permissions
You must have the CREATE_PROCEDURE privilege.
Related Statements
SIGNAL
Last modified date: 12/06/2024