RAISE EXCEPTION
Use the RAISE EXCEPTION statement to simulate the generation of an error.
Syntax
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| error_text | SPL variable or expression that contains error message text for error -746 | Must be a character data type and be valid in the statement block | Identifier; Expression |
| ISAM_error | SPL variable or other expression that represents
an ISAM error number. The default is 0. |
Must return a value in SMALLINT range. You can specify a unary minus sign before error number. | Expression |
| SQL_error | SPL variable or other expression that represents an SQL error number | Same as for ISAM_error | Expression |
Usage
Use the RAISE EXCEPTION statement to simulate an error or to generate an error with a custom message. An ON EXCEPTION statement can trap the generated error.
If
you omit ISAM_error, the database server sets the ISAM error
code to zero (0) when the exception is raised. If
you want to specify error_text but not specify a value for ISAM_error,
specify zero (0) as the value of ISAM_error.
The
RAISE EXCEPTION statement can raise either system-generated exceptions
or user-generated exceptions. For example, the following statement
raises the error number
-208: RAISE EXCEPTION -208, 0;
Here the minus ( - ) symbol is required after the EXCEPTION keyword for error -208; most error codes are negative integers.