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-18
Versions No
VERSIONS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
Views Changed No protection or shorthand views.
See Views on page 6-6.
VIEWS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
VOLUME command No
WHENEVER directive Yes See Section 4, Embedded SQL and
SQL/MX Programming Guide for C
and COBOL
WHERE clause Yes See SQL/MX Reference Manual
WINDOW option Yes See SQL/MX Report Writer Guide
WITH SHARED ACCESS
option
No
! command Yes
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 18 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments