WARNING! Although SQLSTATE is preferred over SQLCODE and SQLCA features, this version only fully supports SQLCODE. A future version will fully support both SQLCA and SQLSTATE.
SQLSTATE is a status parameter. Its codes indicate the status of the most recently attempted procedure—either the procedure completed successfully or an error occurred during the execution of the procedure.
SQLSTATE is a character-string parameter whose exceptions values are described in the following table:
Value |
Description |
|---|---|
00XXX |
Successful execution |
01XXX |
Warning |
02XXX |
No data exists; no rows affected |
Any other value |
Error |
