I'm using the DB2 Control Center Command Window Editor to run simple queries and it works well. But with one small annoyance. If I make a simple error I get the short error message with the SQLSTATE and SQLCODE values and then a very long error explanation that contributes nothing. Anyone know how to turn off the long explanation?

Thanks!

Dave


Here is a (partial) example:

select count(*) from some_table where status_codes = 'E';

SQL0206N "STATUS_CODES" is not valid in the context where it is used.
SQLSTATE=42703

SQL0206N "STATUS_CODES" is not valid in the context where it is used.

Explanation:

This error can occur in the following cases:
* For an INSERT or UPDATE statement, the specified column is not a
column of the table, or view that was specified as the object of the
insert or update.
* For a SELECT or DELETE statement, the specified column is not a
column of any of the tables or views identified in a FROM clause in
the statement.
* For an assignment statement, the reference name does not resolve to
the name of a column or variable.
* For an ORDER BY clause, the specified column is a correlated column
reference in a subselect, which is not allowed.
...
(and on and on for a couple of more pages)