Setting the schema for unqualified objects in SQL statements that run on DB2 for Linux, UNIX, and Windows

When an SQL statement references unqualified objects, those objects are qualified by a default schema. There are several locations in which you can specify the default schema to use.

There are two locations in which you can specify a schema to use for unqualified objects in SQL statements that run on DB2 for Linux, UNIX, and Windows. Here are those locations in order of precedence.

The Run Workload Advisors page of the Invoke section
Specify the schema in the Schema field, which is directly below the Database connection field.
When you specify the schema in this location, the global preference is ignored.
The global preferences
Remember: Close open instances of the workflow assistant before setting this preference.
To set the default schema in the global preferences:
  1. In the main menu, select Window > Preferences.
  2. In the Preferences window, expand Data Management > Visual Explain.
  3. On the EXPLAIN Options page, click the tab labeled DB2 for Linux, UNIX, and Windows.
  4. Type or select a value in the CURRENT SCHEMA field.
  5. Click Apply, then click OK.

Feedback