DB2 Error Codes List

This site contains all DB2 Error Codes

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.codes/src/tpc/db2z_n.htm

Derby - DBVisualizer

Hi

When trying to do a simple query, with Apache Derby Database, on a table name written in CamelCase.

select *
from TBL.TmpEndpoints

I'm getting this error

 13:58:44  [SELECT - 0 row(s), 0.000 secs]  [Error Code: -1, SQL State: 42X05]  Table/View 'TBL.TMPENDPOINTS' does not exist.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec  [0 successful, 0 warnings, 1 errors]

In order to be able to query the table, I need to add double quotes to the table name. My query is :

select *
from TBL."TmpEndpoints"