Unqualified alias, constraint, external program,
index, nodegroup, package, sequence, table, trigger, view,
and XSR object 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. (For more information about CRTSQLxxx commands, see Embedded SQL Programming.) |
| Run SQL Statements | DFTRDBCOL parameter on the Run SQL Statements (RUNSQLSTM) command. (For more information about the RUNSQLSTM command, see SQL Programming.) |
| Call Level Interface (CLI) on the server | SQL_ATTR_DEFAULT_LIB or SQL_ATTR_DBC_DEFAULT_LIB environment or connection variables (For more information about CLI, see SQL Call Level Interfaces (ODBC).) |
| JDBC or SQLJ on the server using IBM® Developer Kit for Java™ | libraries property object (For more information about JDBC and SQLJ, see IBM Developer Kit for Java.) |
| ODBC on a client using the IBM i Access Family ODBC Driver | SQL Default Schema in ODBC Setup (For more information about ODBC, see System i® Access.) |
| JDBC on a client using the IBM Toolbox for Java | SQL Default Schema in JDBC Setup (For more information about JDBC, see System i Access.) (For more information about the IBM Toolbox for Java, see IBM Toolbox for Java.) |
| OLE DB on a client using the IBM i Access Family OLE DB Provider | DefaultCollection in Connection Object Properties (For more information about OLE DB, see System i Access.) |
| ADO .NET on a client using the IBM i Access Family ADO .NET Provider | DefaultCollection in Connection Object Properties (For more information about ADO .NET, see System i Access.) |
| All interfaces | SET SCHEMA or QSQCHGDC (Change Dynamic Default Collection) API (For more information about QSQCHGDC, see the File APIs category.) |