Unqualified object names are implicitly qualified. The rules for qualifying a name differ depending on the type of object that the name identifies.
Unqualified alias, constraint, external program, index, nodegroup, package, sequence, table, trigger, and view names are implicitly qualified by the default schema. The default schema is specified as follows:
SQL Interface | Specification |
---|---|
Embedded SQL | DFTRDBCOL parameter and DYNDFTCOL(*YES) on
the Create SQL Program (CRTSQLxxx) and Create SQL Package (CRTSQLPKG) commands.
The SET OPTION statement can also be used to set the DFTRDBCOL and DYNDFTCOL
values.
|
Run SQL Statements | DFTRDBCOL parameter on the Run SQL Statements
(RUNSQLSTM) command.
|
Call Level Interface (CLI) on the server | SQL_ATTR_DEFAULT_LIB or SQL_ATTR_DBC_DEFAULT_LIB
environment or connection variables
|
JDBC or SQLJ on the server using IBM(R) Developer Kit for Java | libraries property object
|
ODBC on a client using the iSeries Access Family ODBC Driver | SQL Default Library in ODBC Setup
|
JDBC on a client using the IBM Toolbox for Java | SQL Default Library in JDBC Setup
|
OLE DB on a client using the iSeries Access Family OLE DB Provider | DefaultCollection in Connection Object Properties
|
ADO .NET on a client using the iSeries Access Family ADO .NET Provider | DefaultCollection in Connection Object Properties
|
All interfaces | SET SCHEMA or QSQCHGDC (Change Dynamic Default
Collection) API
|
The qualification of data type (both built-in types and distinct types), function, procedure, and specific names depends on the SQL statement in which the unqualified name appears:
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.