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-2
APPENDRESTART
command
No
ASCII character set Yes
AS clause Yes See SQL/MX Report Writer Guide
AS DATE/TIME clause Yes See SQL/MX Report Writer Guide
AUDIT file attribute No See SQL/MP Reference Manual
AUDITCOMPRESS file
attribute
Yes See SQL/MX Reference Manual
Audited tables Yes See SQL/MX Reference Manual
AVG function Yes See SQL/MX Reference Manual
BACKUP utility Yes See SQL/MP Reference Manual
BASETABS table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
BEGIN DECLARE SECTION
statement
Yes See Section 4, Embedded SQL and
SQL/MX Reference Manual
BEGIN WORK statement Yes See Section 3, DML Features and
SQL/MX Reference Manual
BETWEEN predicate Yes See SQL/MX Reference Manual
BLOCKSIZE file attribute Yes Fewer capabilities. See SQL/MX
Reference Manual
BREAK FOOTING command Yes See SQL/MX Report Writer Guide
BREAK ON command Yes See SQL/MX Report Writer Guide
BREAK TITLE command Yes See SQL/MX Report Writer Guide
BUFFERED file attribute No See SQL/MP Reference Manual
CANCEL command Yes See SQL/MX Report Writer Guide
CASE expression Yes See SQL/MX Reference Manual
CAST function Yes See Section 3, DML Features and
SQL/MX Reference Manual
CATALOG command No See SQL/MP Reference Manual
Catalogs Changed See Organization of Catalogs and
Schemas on page 6-2
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 2 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments