SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Creating an SQL/MX Database
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
7-2
Accessing an SQL/MP Database From NonStop
SQL/MX
Accessing an SQL/MP Database From
NonStop SQL/MX
From NonStop SQL/MX, you can run queries on an SQL/MP database located on the
same node. Such queries must conform to these guidelines:

Perform DML operations only. From NonStop SQL/MX, you cannot perform DDL
operations or utility operations on SQL/MP database objects. If you want to
perform DDL operations and utility operations on SQL/MP database objects, you
must do so from NonStop SQL/MP.

Use either valid SQL/MP aliases or Guardian names for SQL/MP objects.

Make sure that all SQL/MP objects comply with the Guardian security conventions
as described in the SQL/MP Installation and Management Guide.

You can mix SQL/MP and SQL/MX tables in the same DML statement. You can
join an SQL/MP and SQL/MX table, create a union of them, and insert data from an
SQL/MP table into an SQL/MX table and visa versa.

You cannot create a view that references both an SQL/MP table and an SQL/MX
table.
For more information about the differences and similarities between NonStop SQL/MX
and NonStop SQL/MP, see the SQL/MX Comparison Guide for SQL/MP Users.
For instructions and examples on executing DDL statements from SQLCI, see the
SQL/MP Installation and Management Guide and the SQL/MP Reference Manual.
Preparing to Create Your SQL/MX Database
Before you begin to create your SQL/MX database, first plan the database and define
its layout as described in Section 4, Understanding and Planning SQL/MX Tables
. Also
plan your security, TMF requirements, RDF requirements, and recovery mechanisms
as described in Section 5, Planning Database Security and Recovery
.
After you create the database, you can load the data into the SQL/MX tables, compile
your application programs, and start running your applications. For information on
managing database applications and modules, see Section 11, Managing Database
Applications.
SQL/MX Subvolume and File Naming
Guidelines
Before you build your SQL/MX database, familiarize yourself with the rules for naming
SQL/MX subvolumes and files. These rules are always followed when NonStop
SQL/MX generates file names and are enforced by NonStop SQL/MX for