SQL/MX Comparison Guide for SQL/MP Users

Quick Reference to Differences
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
2-4
Concurrency Yes See SQL/MX Reference Manual
Constraints Yes In CREATE TABLE and ALTER
TABLE statements. See SQL/MX
Reference Manual
CONSTRNT table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
CONTINUE statement No
CONTROL EXECUTOR
directive
Changed Parallelism enabled through
SYSTEM_DEFAULTS table. See
Section 5, Optimizer and Executor
CONTROL QUERY directive Changed Implemented as CONTROL QUERY
DEFAULT. See Section 3, DML
Features and SQL/MX Reference
Manual
CONTROL TABLE directive Changed See Section 3, DML Features and
SQL/MX Reference Manual
CONVERT command No See SQL/MP Reference Manual
CONVERTTIMESTAMP
function
Yes See SQL/MX Reference Manual
COPY command No See SQL/MP Reference Manual
Correlation names Yes See SQL/MX Reference Manual
COUNT function Yes See SQL/MX Reference Manual
CPRLSRCE table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
CPRULES table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
CREATE CATALOG
statement
Changed No security capabilities. See
SQL/MX Reference Manual
CREATE COLLATION
statement
No See SQL/MP Reference Manual
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 4 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments