Identify warnings with SQLCODE
When the database server executes an SQL statement successfully
but encounters a warning condition, it takes the following actions:
- Sets the SQLSTATE variable to a five-character warning value
- Sets the SQLCODE variable to zero (success)
- Raises the MI_Exception event with the MI_MESSAGE exception level
To identify warnings, examine the value of SQLSTATE. The SQLCODE value does not indicate the cause of a warning.