SQL Guide : Using SQL for database administration : Managing database objects : Setting a catalog and schema context
  
Setting a catalog and schema context
The following example sets a catalog context to C and the schema context to S.
SET CATALOG C;
SET SCHEMA S;
CREATE TABLE T (i INTEGER);
SELECT * FROM T;
-- The name T is resolved to C.S.T
See also
Managing database objects