ASA SQL Reference
SQL Statements
Use this statement to resignal an exception condition.
RESIGNAL [ exception-name ]
Within an exception handler, RESIGNAL allows you to quit the compound statement with the exception still active, or to quit reporting another named exception. The exception will be handled by another exception handler or returned to the application. Any actions by the exception handler before the RESIGNAL are undone.
None.
None.
Using exception handlers in procedures and triggers
SQL/92 Persistent stored module feature.
SQL/99 Persistent Stored Module feature.
Sybase Not supported in Adaptive Server Enterprise. Signaling of errors in Transact-SQL procedures is carried out using the RAISERROR statement.
The following fragment returns all exceptions except Column Not Found to the application.
... DECLARE COLUMN_NOT_FOUND EXCEPTION FOR SQLSTATE '52003'; ... EXCEPTION WHEN COLUMN_NOT_FOUND THEN SET message='Column not found'; WHEN OTHERS THEN RESIGNAL;