i think the problem is that DB2 assumes the schema = the username if
none is provided in the sql. so you're creating all your tables under
schema DB2ADM, and trying to access them as if they were in schema
USER.
i'm unaware of the support for database schemas in Torque. i seem to
remember
Probleme with datasource and maybe SQL:
Hello, I have the following problems :
Basically I use two different users 1 for administating (user=db2adm) and one
only has a reader (user=user).
note :
SELECT * FROM Table1 =>
Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0204N