SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-29
Versioning
Versioning
NonStop SQL/MX database objects inherit their schema's version, regardless of what
features they use. SQL/MP database objects have a feature-based object version.
Aggregates with subquery:
SELECT COUNT(*) FROM t1
WHERE col_a IN (SELECT col_b FROM t2)
YN
Most DSS queries:
SELECT COUNT(*) FROM t1
WHERE col_c<=1 GROUP BY col_a
YN
Statements that reference date-time data types Y N
Data Definition Language statements N N
Data Control Language statements N N
Table 3-6. Query Type Comparison (page 3 of 3)
Type of Query
NonStop
SQL/MP
NonStop
SQL/MX