09-13-11, 15:40 #1Registered User
- Join Date
- Sep 2011
I am trying to get data from table
Getting bellow error..please let me know what does it means
Some data sources do not provide the appropriate values for
"<name>". In these cases, the message token will have the
following format: "OBJECT:<data source> TABLE/VIEW", indicating
that the actual value for the specified data source is unknown.
The statement cannot be processed.
Ensure that the object name (including any required qualifiers)
is correctly specified in the SQL statement and it exists. For
missing data type or function in SOURCE clause, it may be that
the object does not exist, OR it may be that the object does
exist in some schema, but the schema is not present in your
Federated system users: if the statement is DROP NICKNAME, make
sure the object is actually a nickname. The object might not
exist in the federated database or at the data source. Verify
the existence of the federated database objects (if any) and the
data source objects (if any).
sqlcode : -204
sqlstate : 42704
Also i am using Db2 comand editor. how to check existing tables under one data base.
thanks, in advance,
09-13-11, 16:12 #2Registered User
- Join Date
- May 2003
what is the schema name of the table?
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390