ASA SQL Reference

SQL Statements

RESIGNAL statement

Description 

Use this statement to resignal an exception condition.

Syntax 

RESIGNAL [ exception-name ]

Usage 

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.

Permissions 

None.

Side effects 

None.

See also 

• SIGNAL statement
• BEGIN statement
• Using exception handlers in procedures and triggers
• RAISERROR statement [T-SQL]

Standards and compatibility 

• 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.

Example 

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;

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.