displaying db2 error codes in SquirrelSQL

Question

When you run a query in db2 commandline tool you get explanations like:

db2 => select * from sysibm.systables  where owner = 'SAM'  and type = 'T';
SQL0206N  "OWNER" is not valid in the context where it is used.
SQLSTATE=42703

However, when ran in SQL tab in SquirrelSQL you get only:

Error: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OWNER, DRIVER=4.13.127
SQLState:  42703
ErrorCode: -206

Does anybody know of a way of making SquirrelSQL display explanation for the error code like db2 cmd line?

OS: Win 7 x64, db2 10.1

Answer 1

There's a bug in DB2 plugin, I have managed to fix it and posted solution at http://sourceforge.net/p/squirrel-sql/bugs/1073/