13 January,2012 by Jack Vamvas
Within a database multiple SCHEMAS can exist. If a table or view exists in a schema different from the default SCHEMA of the logon and the reference to the object does not include a qualified name , then the object can’t be found.
For example , you may want to do a db2 list tables and view the list pf tables from another schema.
Use the SET CURRENT SCHEMA method.
For example , If the default SCHEMA is DB2TEST , and you want to view the tables of the schema DB2OTHER do:
db2 set current schema = DB2OTHER