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-6
DCL (Data Control
Language) statements
Changed See SQL/MX Reference Manual
Deadlocks Yes See Section 3, DML Features and
SQL/MX Reference Manual
(CONTROL TABLE)
DEALLOCATE file attribute Yes See SQL/MX Reference Manual
DECIMAL_POINT option Yes See SQL/MX Report Writer Guide
DECLARE CURSOR
statement
Yes See SQL/MX Programming Guide
for C and COBOL and SQL/MX
Reference Manual
DCOMPRESS No See SQL/MP Reference Manual
DEFAULT clause Yes See SQL/MX Reference Manual
DEFINEs Yes See SQL/MX Reference Manual
DELETE DEFINE statement Yes See SQL/MX Reference Manual
DELETE statement Yes Some differences. See SQL/MX
Reference Manual and see SQL/MX
Programming Guide for C and
COBOL
DESCRIBE INPUT
statement
Yes See SQL/MX Programming Guide
for C and COBOL and SQL/MX
Reference Manual
DESCRIBE statement Yes See SQL/MX Reference Manual
Detail alias No
DETAIL command Yes See SQL/MX Report Writer Guide
DISPLAY STATISTICS
command
Changed See SQL/MX Reference Manual
DISPLAY USE OF command Changed Differently implemented. See
DISPLAY USE OF Command on
page 7-1, Some functions replaced
by mxtool INFO command
DISTINCT clause Yes See SQL/MX Reference Manual
Data Manipulation Language
(DML) statements
Yes See Section 3, DML Features and
SQL/MX Reference Manual
DOWNGRADE CATALOG
command
No See SQL/MP Reference Manual
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 6 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments