SQL/MX Comparison Guide for SQL/MP Users

HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
2-1
2 Quick Reference to Differences
Table 2-1 lists the content of NonStop SQL/MP as found in the SQL/MP Reference
Manual, the SQL/MX Reference Manual, and other manuals. The column
Implemented In NonStop SQL/MX? indicates whether the item is supported in
NonStop SQL/MX (yes, no, or changed.) “Changed” means that the item is supported
differently in NonStop SQL/MX than it was in NonStop SQL/MP.
NonStop SQL/MX supports Report Writer. In the table, Report Writer commands are
identified in the Comments column.
Remember that NonStop SQL/MX has many features that are not listed here because
this list is NonStop SQL/MP-focused. See the NonStop SQL/MX manuals, especially
the SQL/MX Reference Manual, for further information.
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 1 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments
Access option Changed See Section 3, DML Features
ADD DEFINE Yes See SQL/MX Reference Manual
Aggregate function Yes See Section 3, DML Features and
the SQL/MX Reference Manual
Alias Changed Used differently in each product.
See SQL/MP Reference Manual and
SQL/MX Reference Manual
ALLOCATE file attribute Yes See SQL/MX Reference Manual
ALTER CATALOG statement No
ALTER COLLATION
statement
No
ALTER DEFINE statement Yes See SQL/MX Reference Manual
ALTER INDEX statement Yes Fewer capabilities. See SQL/MX
Reference Manual
ALTER PROGRAM
statement
No
ALTER TABLE statement Yes Fewer capabilities. See SQL/MX
Reference Manual
ALTER VIEW statement No
APPEND command No
APPENDCANCEL command No