SQL messages and codes

Use this topic collection to find descriptions of codes and messages returned when using SQL with DB2® for i. This topic contains listings of SQLCODEs, SQLSTATEs, class codes, and SQL messages.

Note: By using the code examples, you agree to the terms of the Code license and disclaimer information.

What's new for IBM i 7.1
Read about new or significantly changed information for the SQL messages and codes topic collection.
PDF file for SQL messages and codes
You can view and print a PDF file of this information.
SQLCODE and SQLSTATE concepts
This reference provides a list of SQLCODEs and their associated SQLSTATEs. In this reference, you can find instructions for finding a SQLCODE in the message file along with the text for these messages.
Listing of SQLSTATE class codes
This table provides a list of general SQLSTATE classes. Each class links to a list of the more specific SQLSTATE codes that comprise that class.
Listing of SQLSTATE values
The tables in this topic provide descriptions of SQLSTATE codes that can be returned to applications by DB2 for i5/OS. The tables include SQLSTATE values, their meanings, and their corresponding SQLCODE values.
SQL message concepts
SQL messages are displayed when DB2 for i returns an error or warning code to the application that uses it.
Listing of SQL messages
These tables list SQL messages. Use these tables to find message text, cause text, recovery text, and corresponding SQLCODEs and SQLSTATEs.
SQL message finder
Use the SQL message finder to quickly find specific SQL codes and messages. This tool allows you to search for an SQLCODE, message ID, SQLSTATE, or SQLSTATE class code.