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-10
INSERT statement Yes See SQL/MX Reference Manual and
SQL/MX Programming Guide for C
and COBOL
INTERVAL data type Yes See SQL/MX Reference Manual
INTERVAL literal Yes See SQL/MX Reference Manual
INVOKE directive and
command
Changed Some functions replaced by
SQL/MX SHOWDDL command. See
Section 4, Embedded SQL, SQL/MX
Programming Guide for C and
COBOL and SQL/MX Reference
Manual
ISLACK file attribute No
Joins Yes See SQL/MX Reference Manual
JULIANTIMESTAMP function Yes See SQL/MX Reference Manual
Keys Yes See SQL/MX Reference Manual
KEYS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
LEFT_MARGIN option Yes See SQL/MX Report Writer Guide
LIKE predicate Yes See SQL/MX Reference Manual
Limits Yes See SQL/MX Reference Manual
LINE_NUMBER function Yes See SQL/MX Report Writer Guide
LINE_SPACING option Yes See SQL/MX Report Writer Guide
LIST command Yes See SQL/MX Report Writer Guide
Literals Yes See Section 3, DML Features and
SQL/MX Reference Manual
LOAD command Changed Replaced by IMPORT utility. See
SQL/MX Reference Manual
LOCK TABLE statement Yes See SQL/MX Reference Manual
Locking Yes See SQL/MX Reference Manual
LOCKLENGTH file attribute No
LOG command Yes See SQL/MX Reference Manual
LOGICAL_FOLDING option Yes See SQL/MX Report Writer Guide
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 10 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments