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:
- In the main menu, select .
- In the Preferences window, expand .
- On the EXPLAIN Options page, click the tab
labeled DB2 for Linux, UNIX, and Windows.
- Type or select a value in the CURRENT SCHEMA field.
- Click Apply, then click OK.