SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Introduction
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
1-27
Delimiting Reserved Words in Guardian Names
In this three-part name, catalog is the first part of the name, schema is the second
part of the name, and table is the third part of the name. See Catalogs on page 6-3
and Schemas on page 6-105.
For more information about logical name resolution, see Attribute Value ANSI for
Logical Names on page 10-63.
Alias Mappings
To permit the use of logical names, a user table named OBJECTS stores alias names.
The MP_PARTITIONS table stores mappings from logical object names to physical
Guardian locations. See OBJECTS Table on page 10-24 and MP_PARTITIONS Table
on page 10-23.
To create the necessary mappings from logical to physical names, use the CREATE
SQLMP ALIAS statement:
CREATE SQLMP ALIAS catalog.schema.table
[\node.]$volume.subvol.filename
For the complete syntax and semantics, see CREATE SQLMP ALIAS Statement on
page 2-92.
To use ANSI names with the DDL Statements for the Sample Database on page D-3,
you must create an alias for each table that has been created.
For example, suppose that you have created the EMPLOYEE table with the physical
Guardian name $samdb.persnl.employee. To specify the logical name
samdbcat.persnl.employee for the employee table, enter:
CREATE SQLMP ALIAS samdbcat.persnl.employee
$samdb.persnl.employee;
DEFINE Names
NonStop SQL/MX supports the use of DEFINE names as logical names for tables,
views, or partitions in DML statements. When NonStop SQL/MX compiles such
statements, it replaces the DEFINE name (for example, =CUSTOMERS) in the
statement with the associated Guardian physical name. DEFINE names can be
created within MXCI or can be inherited from the TACL process or the OSS shell.
For more information about DEFINEs, see DEFINEs on page 6-38.
Delimiting Reserved Words in Guardian Names
In NonStop SQL/MP, you can use reserved words in Guardian names that identify
tables, views, partitions, and collations. NonStop SQL/MX has many more reserved
words than NonStop SQL/MP. If an SQL/MX reserved word occurs as part of a
Guardian name, you must delimit it by enclosing it in double quotes—that is, it must be
a delimited identifier. See Using SQL/MX Reserved Words in SQL/MP Names
on
page 6-57.