Hi,

I am facing issue accessing db2 table. getting SQLCODE: -204 SQLSTATE: 42704.

I am able to access same table from command line but not through JDBC. Other tables in same schema are accessible but tables which are created at run time are not accessible.

not sure whether it is DB2 or JDBC issue.

DB2 version is 9.5 and OS is AIX.

Can any one please help me out.

Thanks in advance.

Please see 2) in Must Read before posting

Publish complete statements to create the tables.

and may be more information neccesary, depending on your response ...

Here is command I am using to create table:

create table schemaName.tblName(field1 varchar(2),field2 varchar(30));

I am able to access this through following command:

db2 "select * from schemaName.tblName"

but with JDBC it give SQLCODE=-204 SQLSTATE:42704.

SQLCODE -204 corresponds to message SQL0204: SQL0204N

So I guess you are not showing us exactly what you do in the Java code (or you are connecting to a different database or DB2 instance). Or you have not committed the CREATE TABLE yet.

Hi Knut,
Thanks for your reply.
Here is my java code to connect to database and execute sql:

------------Code to establish connection --

Class.forName("com.ibm.db2.jcc.DB2Driver");

String databaseURL = "jdbc:db2://"+host+":"+port+"/"+dbName;

Properties properties = new Properties();

properties.put("user", userId);

properties.put("password", password);

dbConnection = DriverManager.getConnection(databaseURL,properties );


----- Code to execute sql statement

statement=dbConnection.createStatement();

statement.execute("select * from schemaName.tblName");

Thanks,
Anurodh

In this code, where is the create table statement? Are you creating the table within the same application code or it is created by another thread ?

I am manually creating table with following command.

create table schemaName.tblName(field1 varchar(2),field2 varchar(30));

and after that I am able to execute select query from command line using :

db2 "select * from schemaName.tblName"

Only issue with JDBC. I get following error :

com.ibm.db2.jcc.b.eo: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SCHEMANAME.TBLNAME, DRIVER=3.53.95

at com.ibm.db2.jcc.b.bd.a(bd.java:676)

at com.ibm.db2.jcc.b.bd.a(bd.java:60)

at com.ibm.db2.jcc.b.bd.a(bd.java:127)

at com.ibm.db2.jcc.b.gm.c(gm.java:2484)

at com.ibm.db2.jcc.b.gm.d(gm.java:2461)

at com.ibm.db2.jcc.b.gm.a(gm.java:1962)

at com.ibm.db2.jcc.t4.db.g(db.java:138)

at com.ibm.db2.jcc.t4.db.a(db.java:38)

at com.ibm.db2.jcc.t4.t.a(t.java:32)

at com.ibm.db2.jcc.t4.sb.h(sb.java:141)

at com.ibm.db2.jcc.b.gm.bb(gm.java:1933)

at com.ibm.db2.jcc.b.gm.a(gm.java:2799)

at com.ibm.db2.jcc.b.gm.e(gm.java:961)

at com.ibm.db2.jcc.b.gm.execute(gm.java:945)

at Database.insertEntity(Database.java:222)

at Database.main(Database.java:49)

try to create a test program that executes
select distinct creator from sysibm.systables
select creator,name from sysibm.systables where creator='SCHEMANAME'
in that case you can verify if the entry exists in catalog and if connected to correct db
the both commands can also be executed locally to check

Thanks for your reply
I executed command locally and table 'TBLNAME' exists with creator 'SCHEMANAME'.

also I don't have problem accessing other tables in same schema. Only temp tables that are being created during the process or I am creating manually are not accessible.

It started when we migrated application to AIX, application was working fine on Linux server.

Can any one please provide some help on this?

we have given already many hints
you never publish the details we have requested
do some pd/psi to identifiy together with the hints the root of the problem
do step-by-step testing and check after each step
verify always twice that schema/name is specified correctly and in the correct case ..
check the catalogs manually..
we can not see from here what is going on.. or you can request me to come over ..

I have published all the details requested.
Please let me know what else you need. I have following all the instruction and checking every thing manually.

As we said: check that you have committed the transaction executing the CREATE TABLE statement. And also check that you are connected to the correct database at the correct DB2 server.

You may want to execute a query like "SELECT * FROM syscat.tables" to see which tables are available at the server you are running your SQL statement against. If a table with schema name "SCHEMANAME" and unqualified table name "TBLNAME" does not show up in the result, the table simply doesn't exist.