Issuing message help from the command line processor

The message help command provides full message text that is associated with the unique message identifier. The message help command must be issued from the Db2® command line processor (CLP).

Procedure

  • To issue message help command for a unique message identifier, open the command line processor and enter one of the following commands:
    • ? XXXnnnnn
      where XXX represents a valid message identifier prefix and nnnnn represents a valid message number.

      For example, when you issue the ? SQL30081 command, the full SQL30081N message text is returned.

    •     ? nnnnn
      where nnnnn represents a valid message number.

      For example, when you issue the ? 30081 command, the full SQL30081N message text is returned.

  • To issue message help command for an SQLSTATE message, open the command line processor and enter one of the following commands:
    •     ? nnnnn
      where nnnnn is a five-digit SQLSTATE (alphanumeric) value.

      For example, when you issue the ? 58005 command, the message text that is associated with the SQLSTATE code 58005 is returned.

    •     ? nn
      The nn represents the two-digit SQLSTATE class code (first two digits of the SQLSTATE value).

      For example, when you issue the ? 58 command, the message text that is associated with the SQLSTATE class 58 is returned.