16.20 - SQLSTATE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

SQLSTATE

Keyword introducing an sqlstate value for which the exception or completion condition is to be handled.

You can specify any number of sqlstate values prefixed by SQLSTATE or SQLSTATE VALUE in a comma-separated list within each handler declaration.

VALUE
Optional keyword prefixing the sqlstate value.
sqlstate_code
Five-character string value that indicates a completion condition for the SQL statement. This is always delimited by APOSTROPHE characters.
A given sqlstate value cannot be a part of more than one DECLARE HANDLER statements and cannot be repeated within a FOR clause.