This tutorial will show you how to change default behaviour of DB2 when connecting to a database. By default when you connect to DB2, your SCHEMA is set to the username you logged in with.

The CURRENT SCHEMA special register contains the default qualifier to be used for unqualified object references for dynamic SQL statements issued within a specific DB2 connection. The qualifier can be changed by the SET SCHEMA statement.

You can also use the QUALIFIER option of the BIND command to control the schema name used to qualify unqualified database object references for static SQL statements.

This tutorial shows how the default SCHEMA can be changed so that table references will use the schema name rather than the user name that is connected.