SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Introduction
HP NonStop SQL/MX Reference Manual—523725-004
1-22
Using NonStop SQL/MX to Access SQL/MP
Databases
NonStop SQL/MX provides support for nonstandard SQL/MP features so that you can
develop applications that use these databases. However, when you use NonStop
SQL/MX to access an SQL/MP database, you should be aware of some restrictions
involving SQL/MP features that do not directly map to NonStop SQL/MX.
The areas of support and the restrictions on access are:
Naming Objects on
page 1-23
To refer to SQL/MP database objects, use either four-part
Guardian Physical Names, three-part Logical Names, or
DEFINE Names. To accommodate the use of ANSI names,
you must create Alias Mappings from ANSI names to NSK
names.
Delimiting Reserved Words
in Guardian Names on
page 1-24
If a column or table name contains an SQL/MX reserved
word, you must delimit the reserved word in double quotes (").
Selecting or Changing Data
on page 1-25
You can select or change DATETIME Data, INTERVAL Data,
and NCHAR Data
with some restrictions.
Accessing Views
on
page 1-28
You can access both protection and shorthand views with the
same security as within NonStop SQL/MP.
Access Options
on
page 1-28
You can use the SQL/MP access options as synonyms for
SQL/MX access options with some restrictions.
SQL/MP Stored Text
on
page 1-29
You cannot access or manipulate SQL/MP tables or views
that have been defined in specific ways. There are restrictions
on specific types of SQL/MP stored text.
SQL/MP File Organizations
on page 1-30
You cannot access SQL/MP tables that have specific file
organizations
Collations
on page 1-30 You cannot access any SQL/MP tables defined with collations
other than those tables defined with the default collation. You
cannot include the SQL/MP COLLATE option in a GROUP BY
clause or an ORDER BY clause when selecting from an
SQL/MP table.