In DB2, normal select query like the one below, may not work properly
SELECT * FROM table;
In that cases, We need to specify the schema name to query the table.
SELECT * FROM schema.table;
Alternatively, for a query session, we can set the schema beforehand using,
SET SCHEMA schema_name;
Now this query will work fine :)
SELECT * FROM table;
This entry was posted
on Aug 27, 2008
at Wednesday, August 27, 2008
and is filed under
db
. You can follow any responses to this entry through the
comments feed
.