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. You can also specify
a default SQL ID with the authority to run SQL statements.
There are three
locations in which you can set these values. Here they are in order
of precedence.
- The Run Workload Advisors page
of the Invoke section
- Specify the values in the Schema and SQL
ID fields, which are directly below the Database
connection field.
- When you specify the values in this location,
the settings in the other locations are ignored.
- The Data Source Explorer
- In the current connection, right-click the subsystem and select .
- When you specify the values in this location, the settings in
the global preferences are ignored. However, the values in this location
are ignored if you specify the values before running the advisors.
- The global preferences
Remember: Close open instances of the workflow assistant
before setting this preference.
To set these values 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 z/OS.
- Specify the default schema and SQL ID for individual connections.
- Click Apply, then click OK.