Hi everyone!
I am Edwi Feitoza, from São Paulo, Brazil!
Recently I have used Squirrel SQL as my primary SQL Editor, but I am having
problems with error messages.
For example, when I execute a query with some error on Squirrel SQL, the
error log shows me the following message:
"*Error: DB2 SQL Error: SQLCODE=-203, SQLSTATE=42702, SQLERRMC=PERSONGROUP,
DRIVER=3.62.56
SQLState: 42702
ErrorCode: -203
Error:DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098,
SQLERRMC=2;-203;42702;PERSONGROUP, DRIVER=3.62.56
SQLState: 56098
ErrorCode: -727*"
But when I execute the same query on Eclipse, it shows the same error,
however with its description. Like this:
"*A reference to column "PERSONGROUP" is ambiguous.. SQLCODE=-203,
SQLSTATE=42702, DRIVER=3.62.56*"
Look that the presence of error description helps to know the reason of
failure quickly.
I'd like to know why Squirrel SQL does not show the SQL description erros
in log. Detail: the JDBC jar file used in Squirrel SQL and Eclipse are the
same.
Thanks a lot.
--
Edwi Oliveira Santos Feitoza
Ubi Dubium Ibi Libertas
|