470,815 Members | 1,353 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704

Hello,

This is my first time starting a topic here so I hope this is the right
place. I am having problems running SQL queries on a Version 8 DB2
database for Windows Server using the type 4 driver. I get a connection
but when I run a query, I get this error:

DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704

For example if my query was "SELECT * from TABLE" , I would get the
error:

"DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 DB2ADMIN.TABLE" [SELECT
* FROM IDSC.TABLE]

I looked at the error codes online and they do not provide me with any
information I did not already know. Any help would be greatly
appreciated.

Kindest Regards,

Tony

Nov 12 '05 #1
1 176880
"tmugavero" <tm*******@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hello,

This is my first time starting a topic here so I hope this is the right
place. I am having problems running SQL queries on a Version 8 DB2
database for Windows Server using the type 4 driver. I get a connection
but when I run a query, I get this error:

DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704

For example if my query was "SELECT * from TABLE" , I would get the
error:

"DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 DB2ADMIN.TABLE" [SELECT
* FROM IDSC.TABLE]

I looked at the error codes online and they do not provide me with any
information I did not already know. Any help would be greatly
appreciated.

Kindest Regards,

Tony


If the userid you are using is db2admin, and you don't supply a high level
qualifier on the table name, the DB2 assumes that DB2ADMIN is the qualifier
(schema) name. You can use the SET SCHEMA statement before hand, use an
alias, or use the a userid with the same name as your schema.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.