Exception expression

An exception expression creates an exception that can be raised or used as a warning.

SQLEXCEPTION message [SQLSTATE state [, code]] CHAIN exception
Syntax rules
  • Any of the values may be null.

  • message and state 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.

results matching ""

    No results matching ""