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-9
HELP command Changed HTML Help will be provided
HELP TEXT statement No
HISTORY command Yes See SQL/MX Reference Manual
Host identifiers Yes See SQL/MX Programming Guide
for C and COBOL
Host programs Yes See SQL/MX Programming Guide
for C and COBOL
Host variables Yes See Section 4, Embedded SQL and
SQL/MX Programming Guide for C
and COBOL
ICOMPRESS file attribute No
IF/THEN/ELSE clause Yes See SQL/MX Report Writer Guide
IN predicate Yes See SQL/MX Reference Manual
INCLUDE SQLCA directive Changed Use diagnostics area for error
handling. See Section 4, Embedded
SQL and SQL/MX Programming
Guide for C and COBOL
INCLUDE SQLDA directive Changed Use descriptor area for error
handling. See Section 4, Embedded
SQL and SQL/MX Programming
Guide for C and COBOL
INCLUDE SQLSA directive No
INCLUDE STRUCTURES
directive
No
Index keys Yes See SQL/MX Reference Manual
INDEXES table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
Indicator variables and
Indicator parameters
Yes See Section 4, Embedded SQL and
SQL/MX Programming Guide for C
and COBOL
INFO DEFINE statement Yes See SQL/MX Reference Manual
INITIALIZE SQL command Yes See SQL/MX Reference Manual
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 9 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments