IBM DB2 CLP Help System

Target Audience: DB2 Developers

DB2 developers may feel exhausting time when working with CLP when accessing help documents. IBM DB2 enables CLP help reference (like MAN in Unix/Linux).

When SQL query is processed, in case of any failure DB2 returns the error using SQL codes. In CLP interactive mode type the following command to get help reference on SQL Code.

db2> ? sqlxxxx

For example, if the sql state/code is 42701 then, try as follows:

db2> ? sql42701

This command will list out the possible cause of the problem with user actions that could taken place to run query successfully.

Permanent link to this article:

Leave a Reply

Your email address will not be published.