IBM Support

SQL Return Codes and SQLSTATEs

Question & Answer


Question

This document explains how you can find the SQLCODEs and SQLSTATEs for DB2.

Answer

SQLCODEs and SQLSTATEs for DB2 are now available in the Information center.

To locate messages and codes for customers using DB2 UDB for z/OS, please perform search at the following website and perform the following steps:


1. Select the DB2 version.

2. From the expanded left panel, select Troubleshooting for DB2.

3. Select Messages and Codes.


To locate messages and codes for customers using DB2 UDB, use the online feature of the product by performing the following steps:

1. From a Windows environment go to:

      Start --> Programs --> IBM DB2 --> Information

2. From the expanded Information screen, select DB2 Information. This will open either your Web browser or the Information Center.

3. From the Information Center, select the Books tab. Expand Reference, then select Message Reference.

[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":"OS\/390"},{"code":"PF035","label":"z\/OS"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021

UID

swg21081399