-435   AN INVALID SQLSTATE sqlstate IS SPECIFIED IN A RAISE_ERROR FUNCTION, RESIGNAL STATEMENT, OR SIGNAL STATEMENT

Explanation

The SQLSTATE specified in the RAISE_ERROR function, RESIGNAL statement, or SIGNAL statement of a trigger or a routine does not conform to the rules for a valid SQLSTATE.

System action

The statement cannot be processed.

Programmer response

Change the SQLSTATE specified in the RAISE_ERROR function, RESIGNAL statement, or SIGNAL statement so that it conforms to the rules of the statement.

For the RAISE_ERROR function, the SQLSTATE must be a character string containing exactly five (5) characters. It must be of type CHAR defined with a length of five (5), or, a type VARCHAR defined with a length of five (5) or greater. The SQLSTATE value must conform to the following rules:
  • Each character must be from the set of digits ('0' through '9') or non-accented upper case letters ('A' through 'Z').
  • The SQLSTATE class (the first two characters) cannot be '00', '01' or '02' because these characters do not indicate error classes.
  • If the SQLSTATE class (the first two characters) start with the character '0' through '6' or 'A' through 'H', then the subclass (the last three characters) must start with a letter in the range 'I' through 'Z'.
  • If the SQLSTATE class (the first two characters) start with the character '7', '8', '9' or 'I' through 'Z', then the subclass (the last three characters) must be from the set of characters '0' through '9' or 'A' through 'Z'.
For the RESIGNAL and SIGNAL statements, the SQLSTATE value must be exactly five (5) characters that follow the following rules:
  • Each character must be from the set of digits '0' through '9' or non-accented upper case letter 'A' through 'Z'.
  • The SQLSTATE class (the first two characters) cannot be '00' because it represents successful completion.

SQLSTATE

428B3