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-13
Program invalidation No
PROGRAMS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
Protection view No See Views on page 6-6
PURGE command No
PURGEDATA command Yes See SQL/MX Reference Manual
Qualified fileset list No
Quantified predicate Yes See SQL/MX Reference Manual
RECLENGTH file attribute No
RELEASE statement No
REPORT FOOTING
command
Yes See SQL/MX Report Writer Guide
REPORT option No
REPORT TITLE command Yes See SQL/MX Report Writer Guide
Reserved words Yes See SQL/MX Reference Manual
RESETBROKEN file attribute Changed Replaced by mxtool FIXUP
command
RESET DEFINE statement No See SQL/MX Reference Manual
RESET LAYOUT command Yes See SQL/MX Report Writer Guide
RESET PARAM command Yes See SQL/MX Reference Manual
RESET PREPARED
command
No
RESET REPORT command Yes See SQL/MX Report Writer Guide
RESET SESSION command Yes See SQL/MX Report Writer Guide
RESET STYLE command Yes See SQL/MX Report Writer Guide
RESETBROKEN file attribute No
RIGHT_MARGIN option Yes See SQL/MX Report Writer Guide
ROLLBACK WORK
statement
Yes See SQL/MX Reference Manual
ROWCOUNT option Yes See SQL/MX Report Writer Guide
Sample database Yes See SQL/MX Reference Manual
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 13 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments