Appendix C SQLSTATE Values
The system reports the execution results of SQL statements in status variable SQLSTATE while an application
program is running. The application program checks SQLSTATE whenever an SQL statement is to be executed, and
processes SQL information while checking the result of SymfoWARE/RDB processing.
SQLSTATE
Status variable SQLSTATE is a 5-digit character-type variable. The value set in SQLSTATE, the result of an SQL
statement being executed, is known as the status code. The status code is made up of two parts: a 2-digit exception
code, followed by a 3-digit sub-exception code. Table: SQLSTATE values lists the code values for the execution
results of SQL statements.
[Table: SQLSTATE values]
201