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-15
Similarity checks Changed Handled internally by NonStop
SQL/MX. See Similarity Checks and
Automatic Recompilation on
page 4-13
SLACK file attribute No
SMF No SQL/MX objects cannot be on
SMF-managed volumes.
SPACE option Yes See SQL/MX Report Writer Guide
SQL directive Yes See SQL/MX Programming Guide
for C and COBOL
SQL identifiers Yes See SQL/MX Reference Manual
SQLDA area Changed See Dynamic SQL on page 4-6
SQLCI Changed MXCI in NonStop SQL/MX. See
SQL/MX Reference Manual for
MXCI command. See SQL/MP
Reference Manual for SQLCI
command.
SQLCI commands Changed MXCI in NonStop SQL/MX. See
MXCI Commands in SQL/MX
Reference Manual
SQLCODE Changed See SQL/MX Programming Guide
for C and COBOL
SQLCOMP command Changed MXCI in NonStop SQL/MX. See
SQL/MX Programming Guide for C
and COBOL
SQLSA area No See Statistics Area on page 4-10
Standards conformance Yes See Section 1, Comparing the
Differences in the Products and
SQL/MX Reference Manual
Statements Yes Some differences. See SQL DML
Statements on page 3-12 and
SQL/MX Reference Manual
Static SQL Yes See SQL/MX Programming Guide
for C and COBOL
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 15 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments