Description
- SQLSTATE VALUE
- Specifies the SQLSTATE that will be signalled. The specified
value must not be null and must follow the rules for SQLSTATEs:
- Each character must be from the set of digits ('0' through '9') or non-accented
upper case letters ('A' through 'Z').
- The SQLSTATE class (first two characters) cannot be '00' since this represents
successful completion.
If the SQLSTATE does not conform to these rules, an error is returned.
- sqlstate-string-constant
- The sqlstate-string-constant must be a character
string constant with exactly 5 characters.
- sqlstate-string-variable
- The sqlstate-string-variable must
be a character or Unicode graphic variable. The actual length of the contents
of the variable must be 5.
- SET
- Introduces the assignment of values to condition-information-items. The condition-information-item values can be
accessed using the GET DIAGNOSTICS statement. The only condition-information-item that can be accessed in the SQLCA is MESSAGE_TEXT.
- MESSAGE_TEXT
- Specifies a string that describes the error or warning.
If an SQLCA
is used,
- the string is returned in the SQLERRMC field of the SQLCA
- if the actual length of the string is longer than 70 bytes, it is truncated
without a warning.
- CONSTRAINT_CATALOG
- Specifies a string that indicates the name of the database that contains
a constraint related to the signalled error or warning.
- CONSTRAINT_SCHEMA
- Specifies a string that indicates the name of the schema that contains
a constraint related to the signalled error or warning.
- CONSTRAINT_NAME
- Specifies a string that indicates the name of a constraint related to
the signalled error or warning.
- CATALOG_NAME
- Specifies a string that indicates the name of the database that contains
a table or view related to the signalled error or warning.
- SCHEMA_NAME
- Specifies a string that indicates the name of the schema that contains
a table or view related to the signalled error or warning.
- TABLE_NAME
- Specifies a string that indicates the name of a table or view related
to the signalled error or warning.
- COLUMN_NAME
- Specifies a string that indicates the name of a column in the table
or view related to the signalled error or warning.
- CURSOR_NAME
- Specifies a string that indicates the name of a cursor related to the
signalled error or warning.
- CLASS_ORIGIN
- Specifies a string that indicates the origin of the SQLSTATE class related
to the signalled error or warning.
- SUBCLASS_ORIGIN
- Specifies a string that indicates the origin of the SQLSTATE subclass
related to the signalled error or warning.
- variable
- Identifies a variable that must be declared in accordance with the rules
for declaring variables (see References to host variables). The variable contains
the value to be assigned to the condition-information-item. The variable must be defined as CHAR, VARCHAR, Unicode GRAPHIC, or
Unicode VARGRAPHIC variable.
- diagnostic-string-constant
- Specifies a character string constant that contains the value to be
assigned to the condition-information-item.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.