SQLState listing

This section will help you interpret error messages generated from SQL or CLI.

• Summary of SQLState class codes contains a listing of the general categories for errors.
• SQLState messages reported by SQL, SQLState messages reported by CLI, and SQLState messages reported by JDBC contain descriptions of each error, and for SQL, provide the name of the function that generated it.

You can also find SQLSTATE descriptions by using a DB2 command line processor, if you have DB2 UDB installed:

1. To open the command line processor, select Start --> Program --> DB2 --> Command Line Processor.
2. On the command line, type ? [SQLSTATE].

Zugehörige Referenzen

• Overview of DB2 Everyplace SQL statement support
• Data type compatibility for assignments and comparisons
• Summary of SQLState class codes