SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-49
Object Naming
The three-part logical name of the form catalog.schema.object is an ANSI name.
The parts catalog and schema denote the ANSI-defined catalog and schema.
To be compliant with ANSI SQL:1999, NonStop SQL/MX provides support for ANSI
three-part object names. By using these names, you can develop ANSI applications
that access all SQL/MP objects. You must create an alias for SQL/MP objects. See
CREATE SQLMP ALIAS Statement on page 2-70 and ALTER SQLMP ALIAS
Statement on page 2-8 for more information.
NAMETYPE Attribute
The NAMETYPE attribute determines the precedence rules for object naming
according to whether the value of the attribute is ANSI or NSK. The value of the
NAMETYPE attribute is determined according to rules applied in this order:
1. The SET NAMETYPE statement and CONTROL QUERY DEFAULT statement
have the same precedence:
•
If you issue a SET NAMETYPE statement, the compiler uses the setting
determined by this statement as the value of the attribute.
Use the SET NAMETYPE statement in MXCI. For embedded SQL, the SET
NAMETYPE statement affects only dynamic embedded SQL. The DECLARE
NAMETYPE statement affects only static embedded SQL.
•
For SQL statements issued through MXCI and embedded SQL, the compiler
uses the NAMETYPE value set by the CONTROL QUERY DEFAULT
statement (if issued).
SCHEMA Default schema (without catalog) name, used if no second part
is specified in a three-part logical name. The schema name can
be qualified by a catalog name, in which case this catalog name
supersedes any settings for the CATALOG attribute. If not set,
the user name of the current user becomes the default second
part of the logical name.
In SQL/MX Release 2.0, the three-part name is an ANSI name.
The parts catalog and schema denote the ANSI-defined catalog
and schema.
MP_SUBVOLUME Default physical subvolume, used if no subvolume is specified
in the Guardian name. If not set, the default subvolume is
specified by the =_DEFAULTS define.
MP_SYSTEM Default system name, used if no system is specified in the NSK
name. If not set, the default system is specified by the
=_DEFAULTS define.
MP_VOLUME Default physical volume, used if no volume is specified in the
NSK name. If not set, the default volume is specified by the
=_DEFAULTS define.
Attribute Setting