On 27-Mar-2014 09:57 -0700, Ken Killian wrote:
SQL Managers cannot use a "LIBRARY-LIST" like Green Screen...
I am not sure of the intended implication, not knowing what "SQL
Managers" means, but the OS does provide for SQL from clients to operate
with "System naming" support via the drivers provided. That is /the
same/ support as provided in the native DB2 for i SQL; e.g. the
green-screen interfaces such as SQL requests issued within STRSQL. See
the doc link included later.
<<SNIP>>
I have no idea "Default Schema" is used for, because *no matter what*
I put in there, it does not work!
PS. Does anyone know what the "Default Schema" does in the Data
Perspective?
FWiW: For how "default schema" is defined by the DB2 for i SQL, refer
to the following doc; presumably the interface to the DB2 via the Data
Perspective is enabled via one of the "interfaces" listed [likely either
JDBC or ODBC], in the table at the bottom of the page:
IBM i 7.1 Information Center -> Database -> Reference -> SQL reference
-> Language elements -> Naming conventions -> Qualification of
unqualified object names
<
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzqualun1.htm>
_Unqualified alias, constraint, ... object names_
"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:
...
• For dynamic SQL statements the default schema depends on whether a
default schema has been explicitly specified. The mechanism for
explicitly specifying this depends on the interface used to dynamically
prepare and execute SQL statements.
• If a default schema is not explicitly specified:
• For SQL naming, the default schema is the run-time
authorization identifier.
• For system naming, the default schema is the job library list
(*LIBL).
• The default schema is explicitly specified through the following
interfaces:
Table 1. Default Schema Interfaces"
..."
Note: the "authorization identifier" is the user profile [name].
midrange.com
