DB2 SET CURRENT SCHEMA

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

See Also

ADMIN_DROP_SCHEMA to drop a schema