Use this page to set the default values for the database
manager to use when processing SQL statements.
- Default schema
- Select or type the name of the schema to use for unqualified database
object references in SQL statements. If you want SQL statements to
refer to database objects that are in other schemas, you must qualify
the names of the objects with the names of their corresponding schemas.
- The schema name that you specify is also used for the routines
that you are deploying where the schema is not explicitly specified.
- Omit current schema in generated statements
- Select to omit schema names in SQL statements.
- Default path
- Type the SQL path to use when resolving function references and
data type references in dynamically prepared SQL statements. This
value is also used to resolve stored procedure references in CALL
statements.
- The default path is not used when you run stored procedures and
user-defined functions from the Data Source Explorer.
- Specify the default path as a list of one or more comma-separated
schema names. To preserve case, enclose a schema name
in double quotation marks; for example, FERMAT, "McDrw #8",
SYSIBM.