NexusDB Guide > SQL Reference > SQL Statements > Control Statements

NexusDB V3 Manual

TRY statement

NexusDB Manual V3 > SQL Reference > SQL Statements > Control Statements

Specify a TRY..CATCH block.

Syntax

<try statement> ::=

TRY <protected statement block> <catch clause>... END

<catch clause> ::= CATCH error-condition [ <catch statement block> ]

Usage

The TRY statement is used to protect a block of SQL statements, and handle some or all of the possible errors that might occur during the execution, gracefully in SQL code. The concept is similar to TRY statements found in many programming languages.

Notes

§	Several CATCH clauses may be specified, but at least one is required.

§	A specific error-condition can be determined by evaluating the current error message using the ERROR_MESSAGE system function.

§	The statement block of the first CATCH clause that evaluates to true is executed.

§	If none of the CATCH clauses evaluates to true, then the current exception is raised.

Examples

1)	The following example shows the TRY statement used to control an explicit transaction:

START TRANSACTION;

TRY

// Execute some data-change statements here.

COMMIT;

CATCH POSITION( 'Unable to open table' IN ERROR_MESSAGE ) <> 0

ROLLBACK;

SIGNAL ERROR_MESSAGE;

END;

Conformance

NexusDB extensions

TRY statement

nexus_logo