SQL default schema
Specifies the default SQL schema.
SQL statements can be created without specifying the schema that an
object is located in. The objects in the SQL statement are said to be unqualified.
For example, in the SQL statement:
SELECT *
FROM QCUSTCDT
QCUSTCDT is an unqualified object. The schema that is used to locate the table name QCUSTCDT is called the
implicit qualifier.
Notes:
- If an SQL default schema is specified, it will be used as the implicit qualifier.
The SQL default schema will also be the first item in the schema list.
- If an SQL default schema is not explicitly specified, one of the following applies:
- For SQL naming, the implicit qualifier is the run-time authorization. This is
a schema with the same name as the user profile specified on the JDBC connection.
- For system naming, the implicit qualifier is the job schema list.
See Schema list for information on how to add other schemas to the schema list.