SQLEXCEPTION message [SQLSTATE state [, code]] CHAIN exception
Exception expression
An exception expression creates an exception that can be raised or used as a warning.
Usage
Syntax rules
-
Any of the values may be null.
-
message
andstate
are string expressions that specify the exception message and SQL state. Teiid does not fully comply with the ANSI SQL specification on SQL state usage, but you are allowed to set any SQL state you choose. -
code
is an integer expression that specifies the vendor code. -
exception
must be a variable reference to an exception or an exception expression, and will be chained to the resulting exception as its parent.