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-11
MAX function Yes See SQL/MX Reference Manual
MAXEXTENTS file attribute Yes See SQL/MX Reference Manual
Message file Changed See SQL/MX Online Help (HTML
format) for messages and online
help text
MIN function Yes See SQL/MX Reference Manual
MODIFY CATALOG
command
No
MODIFY LABEL command No
MODIFY REGISTER
command
No
Multibyte character sets Yes
NAME command Yes See SQL/MX Report Writer Guide
NAME option No
Name resolution Yes See SQL/MX Reference Manual and
SQL/MX Programming Guide for C
and COBOL
Names Yes See SQL/MX Reference Manual
NEWLINE_CHAR option Yes See SQL/MX Report Writer Guide
Nonaudited tables No
NOPURGEUNTIL file
attribute
No
NULL predicate Yes See SQL/MX Reference Manual
Null values Yes See SQL/MX Reference Manual
NULL_DISPLAY Yes See SQL/MX Report Writer Guide
Numeric data types Yes See SQL/MX Reference Manual
Numeric literals Yes See SQL/MX Reference Manual
OBEY command Yes See SQL/MX Reference Manual
OCTET_LENGTH function Yes See SQL/MX Reference Manual
OPEN statement Yes See SQL/MX Reference Manual
OSS names Yes
OUT command No
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 11 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments