DSNH435I E csectname 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.

User response

Correct the SQLSTATE specified in the RAISE_ERROR function or SIGNAL or RESIGNAL 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' since this represents successful completion.

Severity

8 (error)