SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Tables to SQL/MX Tables
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-2
ANSI Compliance
ANSI Compliance
NonStop SQL/MX is open, portable, and, most importantly, uses an industry standard:
the American National Standards Institute (ANSI) version of SQL. SQL/MX is based on
ANSI SQL:1999 and includes support for features from higher levels of the standard.
SQL/MX supports the creation of ANSI-compliant catalogs, schemas, and database
objects. SQL/MX uses three-part ANSI names, consisting of the catalog, schema, and
object name, to refer to database objects:
catalog.schema.object
SQL/MX views are ANSI-compliant and offer the following advantages:

No view text limit

Aggregations and unions specified in view text (aggregate over a view or joined to
another table)

Updatable

Security model that does not require users to have privileges on the underlying
tables unlike NonStop SQL/MP
For more information about how SQL/MX features comply with ANSI standards, see
the
SQL/MX Reference Manual.
New Functionality in NonStop SQL/MX
NonStop SQL/MX includes useful functionality for database objects that NonStop
SQL/MP does not have. This functionality includes the following:

Triggers

Referential integrity constraints

Hash partitioning

Unicode character set
For more information, see the
SQL/MX Reference Manual.
Enabling SQL/MX Applications to Access Specific Tables
If you are using NonStop SQL/MX to query SQL/MP tables, you might need to convert
a SQL/MP table to a SQL/MX table. Your application might require functionality that is
not supported in NonStop SQL/MP, or the application might need to access data in a
SQL/MP table that NonStop SQL/MX cannot access. For example, NonStop SQL/MX
cannot query relative tables or entry-sequenced tables that are partitioned. If your
database consists of relative tables and you want to use features in NonStop SQL/MX,
you might consider converting your database to SQL/MX tables.