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

SQL/MX Language Elements
HP NonStop SQL/MX Reference Manual—540440-003
6-12
Database Object Names
Database Object Names
Logical Names for SQL/MX Objects
Physical Names for SQL/MP Objects
Logical Names for SQL/MP Objects
DEFINE Names for SQL/MP Objects
SQL/MX Object Namespaces
Considerations for Database Object Names
SQL/MX DML statements can refer to SQL/MX database objects and SQL/MP
database objects. To refer to a database object in a statement, use an appropriate
database object name. For more information on the types of database objects, see
Database Objects on page 6-11.
Logical Names for SQL/MX Objects
You can refer to an SQL/MX table, stored procedure, or view by using a three-part
logical name, also called an ANSI name:
catalog-name.schema-name.object-name
In this three-part name, catalog-name is the name of the catalog, schema-name is
the name of the schema, and object-name is the simple name of the table, stored
procedure, or view. Each of the parts is an SQL identifier. See Identifiers on page 6-52.
The NAMETYPE attribute defaults to ANSI, allowing you to use logical names of
SQL/MX objects.
NonStop SQL/MX automatically qualifies an object name with the current default
catalog and schema name unless you explicitly specify catalog and schema names
with the object name. A two-part name schema-name.object-name is qualified
implicitly with the current default catalog. A one-part name object-name is qualified
implicitly with the default schema and catalog.
You can qualify a column name in an SQL/MX statement by using a three-part, two-
part or one-part object name, or a correlation name.
For more information about the default catalog and schema, and the NAMETYPE
attribute, see Object Naming on page 10-48.
Physical Names for SQL/MP Objects
Physical names of tables and views are qualified with the system node, volume, and
subvolume names. SQL/MP tables and views are created with Guardian physical
names of the form:
[\node.][[$volume.]subvol.]filename
In this four-part name, \node is the name of a node on a NonStop system, $volume
is the name of a disk volume, subvol is the name of a subvolume, and filename is
the name of a Guardian disk file or the name of an SQL/MP table or view.