Search results
Learn how Db2 returns SQLCODE and SQLSTATE after executing an SQL statement, and how to handle them in your application program. See the meaning and examples of SQL codes, tokens, and SQLCA.
- Error (−) SQL codes
Error (−) SQL codes. SQL return codes that are preceded by a...
- SQLCODE -206
Possible reasons for this error include: The specified name...
- Error (−) SQL codes
Error (−) SQL codes. SQL return codes that are preceded by a minus sign (−) indicate that the SQL statement execution was unsuccessful.
Possible reasons for this error include: The specified name is not a column of any of the source or target tables or views of the statement. In a SELECT or DELETE statement, the specified name is not a column of any of the tables or views that are identified in a FROM clause in the statement.
In an exception handler, the SQLCODE function returns the numeric code of the exception being handled. (Outside an exception handler, SQLCODE returns 0 .) For an internally defined exception, the numeric code is the number of the associated Oracle Database error.
9 cze 2023 · The SQLCODE function returns the number code of the most recent exception. This number code is an ANSI-standard code, which means it is the same for all relational databases. It is different from the ORA codes, which you may also get when working with Oracle databases.
In an exception handler, the SQLCODE function returns the numeric code of the exception being handled. (Outside an exception handler, SQLCODE returns 0 .) For an internally defined exception, the numeric code is the number of the associated Oracle Database error.
In this tutorial, you will learn how to handle other unhandled exceptions in the WHEN OTHER clause using SQLCODE and SQLERRM functions.
