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

Standard SQL and SQL/MX
HP NonStop SQL/MX Reference Manual—540440-003
E-6
SQL/MX Extensions to Standard SQL
NonStop SQL/MX does not support these Core SQL:1999 features:
NonStop SQL/MX supports embedded language. NonStop SQL/MX does not support
E182, module language. Even though this feature is listed in Table 31 in the standard,
Core SQL:1999 allows a choice between module language and embedded language.
Module language and embedded language are identical in capability. They differ only
in how SQL statements are associated with the host programming language.
SQL/MX Extensions to Standard SQL
NonStop SQL/MX provides many features that enhance or supplement the functionality
of standard SQL. In your SQL/MX applications, you can use these extensions just as
you can use Core SQL:1999. This table shows the Non-Core extensions that NonStop
SQL/MX supports:
ID Feature
E153 Updatable queries with subqueries
F021 Basic information schema
F501 Features and conformance views
F812 Basic flagging
S011 Distinct data types
ID Feature
B021 Direct SQL
B031 Basic dynamic SQL
B032 Extended dynamic SQL
F111 Isolation levels other than SERIALIZABLE
F121 Basic diagnostics management
F171 Multiple schemas per user
F222 INSERT statement: DEFAULT VALUES clause
F281 LIKE enhancements
F321 User authorization (no support for SYSTEM_USER)
F381-02 ALTER TABLE statement: ADD CONSTRAINT clause
F381-03 ALTER TABLE statement: DROP CONSTRAINT clause
F401-01 NATURAL JOIN
F401-04 CROSS JOIN
F461 Named character sets
F491 Constraint management
F561 Full value expressions
F651 Catalog name qualifiers
T171 LIKE clause in table definition (not exact Core SQL:1999 syntax)