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-12
OUT_REPORT command Yes See SQL/MX Report Writer Guide
OVERFLOW_CHAR
command
Yes See SQL/MX Report Writer Guide
OWNER file attribute No
PAGE_COUNT option Yes See SQL/MX Report Writer Guide
PAGE_FOOTING option Yes See SQL/MX Report Writer Guide
PAGE_LENGTH option Yes See SQL/MX Report Writer Guide
PAGE_NUMBER option Yes See SQL/MX Report Writer Guide
PAGE TITLE option Yes See SQL/MX Report Writer Guide
Parallel index loading Changed NonStop SQL/MX does parallel
index loading by default. It is not a
specifiable attribute.
Parameters Yes No TYPE AS clause. See SQL/MX
Reference Manual
PARTITION clause Yes See SQL/MX Reference Manual
Partitions Yes See SQL/MX Reference Manual
Partition management Yes Performed by SQL/MX MODIFY
command. See SQL/MX Reference
Manual
PARTNS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
PERUSE command No
Plans Yes See SQL/MX Query Guide
POSITION function Yes See SQL/MX Reference Manual
Predicates Yes See Section 3, DML Features and
SQL/MX Reference Manual
PREPARE statement Yes See SQL/MX Reference Manual and
SQL/MX Programming Guide for C
and COBOL
Primary keys Yes See SQL/MX Reference Manual
Print item No
PROGID file attribute No
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 12 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments