By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

I am a new user help needed

P: n/a
N P
This is the Query which i am using
describe table db2prod.c9t_assignment

but i get an error
describe table db2prod.c9t_assignment

DB21033E The command is not valid for databases that reside on DRDA
hosts.

for the query
SELECT *
FROM db2prod.USER_TABLES

DBA2191E SQL execution error.

com.ibm.db.DataException: A
database manager error occurred. : [IBM][CLI Driver][DB2]
SQL0204N "DB2PROD.USER_TABLES" is an undefined name.
SQLSTATE=42704

Can anyone help me in this

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"N P" <np***@allstate.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
This is the Query which i am using
describe table db2prod.c9t_assignment

but i get an error
describe table db2prod.c9t_assignment

DB21033E The command is not valid for databases that reside on DRDA
hosts.

for the query
SELECT *
FROM db2prod.USER_TABLES

DBA2191E SQL execution error.

com.ibm.db.DataException: A
database manager error occurred. : [IBM][CLI Driver][DB2]
SQL0204N "DB2PROD.USER_TABLES" is an undefined name.
SQLSTATE=42704

Can anyone help me in this

What OS is your DB2 server located on?

If you work for Allstate, you should contact one of your DBA's for help.
Nov 12 '05 #2

P: n/a
Mainframe hosts do not support all the functionality of DB2 for Linux
,Unix ,Windows and OS/2.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.