SQL CODES AND SQL STATES

SQLCODE

An SQLCODE is a return code. The return code is sent by the database manager after completion of each SQL statement.

SQL STATE

SQLSTATE provides application programs with common return codes for success, warning, and error conditions

SQLSTATE values are particularly useful when handling errors in distributed SQL applications. SQLSTATE values are consistent with the SQLSTATE specifications contained in the SQL 1999 standard.

An SQLSTATE value is a return code that indicates the outcome of the most recently executed SQL statement