User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

Resignal an exception condition.

Syntax

     RESIGNAL [ exception-name ]

Usage

Within an exception handler in a procedure or trigger.

Permissions

None.

Side effects

None.

See also

• SIGNAL statement
• Compound statements
• "Using exception handlers in procedures and triggers"

Description

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 not undone.

Example

The following fragment returns all exceptions except for 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 ;