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.