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-14
SAVE command No
Search conditions Yes See SQL/MX Reference Manual
SECURE command No Replaced by GRANT and REVOKE
statements. See SQL/MX Reference
Manual
SECURE file attribute No
Security Yes See SQL/MP Reference Manual
SELECT statement Yes Some differences. See SQL/MX
Reference Manual
SERIALWRITES file attribute No
SET DEFINE statement Yes See SQL/MX Reference Manual
SET DEFMODE command No
SET LAYOUT command Yes See SQL/MX Report Writer Guide
SET PARAM command Yes See SQL/MX Reference Manual
See SQL/MX Report Writer Guide
SET SESSION command No
SET STYLE command Yes See SQL/MX Report Writer Guide
SETSCALE function Changed See Section 4, Embedded SQL
Shorthand view No See Views on page 6-6
SHOW CONTROL command Yes See SQL/MX Reference Manual
SHOW DEFINE statement Yes See SQL/MX Reference Manual
SHOW DEFMODE
command
No
SHOW LAYOUT command Yes See SQL/MX Report Writer Guide
SHOW PARAM command Yes See SQL/MX Reference Manual
SHOW PREPARED
command
No
SHOW REPORT command Yes See SQL/MX Report Writer Guide
SHOW SESSION command Yes See SQL/MX Reference Manual
See SQL/MX Report Writer Guide
SHOW STYLE command Yes SQL/MX Report Writer Guide
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 14 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments