SQL messages and codes

 

Use this topic collection to find descriptions of codes and messages returned when using SQL with DB2 Universal Database™ for iSeries™ (DB2^® UDB for iSeries). This topic contains listings of SQLCODEs, SQLSTATEs, class codes, and SQL messages.

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

• What's new for V5R4
  This topic highlights the changes made to this topic collection for V5R4.

• Printable PDF
  Use this to view and print a PDF 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 UDB for iSeries. The tables include SQLSTATE values, their meanings, and their corresponding SQLCODE values.

• SQL message concepts
  SQL messages are displayed when a DB2 Universal Database for iSeries 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.