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-3
CATALOGS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
CENTER_REPORT option Yes See SQL/MX Report Writer Guide
Character data type Yes See SQL/MX Reference Manual
Character expression Yes See SQL/MX Reference Manual
Character sets Yes See SQL/MX Reference Manual
CHAR_LENGTH function Yes See SQL/MX Reference Manual
CLEANUP command No
CLEARONPURGE file
attribute
Yes See SQL/MX Reference Manual
CLOSE statement Yes See SQL/MX Reference Manual
Clustering keys Yes See SQL/MX Reference Manual
COLLATE clause Changed Can only be specified as COLLATE
DEFAULT. See SQL/MX Reference
Manual
Collation definitions No
Collations Yes Fewer capabilities. See SQL/MX
Reference Manual
Column Identifier No See SQL/MP Reference Manual
Columns Yes See SQL/MX Reference Manual
COLUMNS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
COMMENT statement No
Comments Yes See SQL/MX Reference Manual
COMMENTS table No See SQL/MP Reference Manual
COMMIT option No
COMMIT WORK statement Yes See SQL/MX Reference Manual
Comparison predicate Yes See SQL/MX Reference Manual
COMPUTE_TIMESTAMP
function
No
CONCAT clause Yes See SQL/MX Report Writer Guide
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 3 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments