15.10 - SQLEXCEPTION - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

A keyword identifier for generic conditions.

You can specify these individually or in combination with one another, but you cannot specify any of them more than once within a given DECLARE HANDLER statement.

SQLEXCEPTION indicates a generic exception condition.

SQLWARNING
SQLWARNING indicates a generic completion condition.
NOT FOUND
NOT FOUND indicates a generic completion condition when no data is found.
condition_name
condition_name is a name that can be used to specify conditions for a handler to act on when the procedure definition specifies the condition name in a SIGNAL or RESIGNAL statement.