| |
- Causa
- AN INVALID SQLSTATE sqlstate IS SPECIFIED IN THE FUNCTION RAISE_ERROR OR IN A SIGNAL SQLSTATE STATEMENT.
The SQLSTATE specified in the RAISE_ERROR function or specified in a SIGNAL SQLSTATE statement of a trigger definition does not conform to the
rules for an application defined SQLSTATE.
- Ação do sistema
- The statement cannot be processed.
- Resposta ao Desenvolvedor
- Correct the SQLSTATE specified in the RAISE_ERROR function or SIGNAL statement.
The SQLSTATE must be a character string containing exactly 5 characters.
It must be of type CHAR defined with a length of 5, or a type VARCHAR defined with a length of 5 or greater.
The SQLSTATE value must follow the rules for application-defined SQLSTATEs as follows:
- 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', '01' or '02' because these are not error classes.
- If the SQLSTATE class (first two characters) starts with the character '0' through '6' or 'A' through 'H', then the subclass (last three
characters) must start with a letter in the range 'I' through 'Z'.
- If the SQLSTATE class (first two characters) starts with the character '7', '8', '9' or 'I' though 'Z', then the subclass (last three
characters) can be any of '0' through '9' or 'A' through 'Z'.
SQLSTATE: 428B3
© Copyright IBM Corp.
|
| |
