SQL messages in Watson Query

Important: IBM Cloud Pak® for Data Version 4.8 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.8 reaches end of support. For more information, see Upgrading from IBM Cloud Pak for Data Version 4.8 to IBM Software Hub Version 5.1.

You can use the SQL message information to identify a problem and to resolve the problem by taking appropriate action.

Symptoms

Message identifiers consist of an alphabetic message prefix followed by a message number and a single letter suffix; for example, SQL0123N. The prefix identifies the component that generates the message. SQL messages have a prefix of SQL. The single letter suffix describes the severity of the message. Message identifiers that end with E are error messages and message identifiers that end with W are warning messages.

Some messages include tokens, or message variables. When a message that contains tokens is generated by Watson Query, each token is replaced by a value that is specific to the error condition that was encountered.

Resolving the problem

You can find detailed information about a specific Watson Query message in the IBM® Db2® product documentation such as Introduction to messages and a detailed list of SQL messages.