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-7
DOWNGRADE SYSTEM
CATALOG command
No See SQL/MP Reference Manual
DROP statement Changed Replaced by specific DROP object
statements. See SQL/MX Reference
Manual
DROP SYSTEM CATALOG
statement
Changed Replaced by DROP SQL statement.
See SQL/MX Reference Manual
DSL (Data Status Language)
statements
No
DSLACK file attribute No See SQL/MP Reference Manual
DUP command Yes See SQL/MX Reference Manual
Dynamic SQL Yes See Section 4, Embedded SQL and
SQL/MX Programming Guide for C
and COBOL
EDIT command No
Embedded SQL Yes See Section 4, Embedded SQL,
SQL/MX Reference Manual,
SQL/MX Programming Guide for C
and COBOL, and SQL/MX
Programming Guide for C and
COBOL.
END DECLARE SECTION
statement
Yes See SQL/MX Reference Manual
ENV command Yes See SQL/MX Reference Manual
ERROR command Yes See SQL/MX Reference Manual
Error messages Yes See SQL/MX Reference Manual
EXECUTE statement Yes See SQL/MX Reference Manual
EXECUTE IMMEDIATE
statement
Yes See SQL/MX Reference Manual
EXISTS predicate Yes See SQL/MX Reference Manual
EXIT command Yes See SQL/MX Reference Manual
EXPLAIN directive Changed See Section 5, Optimizer and
Executor, SQL/MX Query Guide,
and SQL/MX Reference Manual
Expressions Yes See SQL/MX Reference Manual
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 7 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments