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-16
Statistics Changed See Section 5, Optimizer and
Executor and SQL/MX Reference
Manual
HP NonStop Storage
Management Foundation
(SMF)
No SQL/MX objects cannot be on
SMF-managed volumes.
Stored procedures Yes See SQL/MX Guide to Stored
Procedures in Java
String functions Yes See Section 3, DML Features and
SQL/MX Reference Manual
String literals Yes See SQL/MX Reference Manual
Subqueries Yes See SQL/MX Reference Manual
SUBSTRING function Yes See SQL/MX Reference Manual
SUBTOTAL command Yes See SQL/MX Report Writer Guide
SUBTOTAL_LABEL option Yes See SQL/MX Report Writer Guide
SUM function Yes See SQL/MX Reference Manual
Super ID Yes See Authorization ID in SQL/MX
Reference Manual
SYSKEY Yes See SQL/MX Reference Manual
System catalog Changed Known as Metadata in NonStop
SQL/MX. See SQL/MX Reference
Manual
SYSTEM command No
System DEFINEs Yes See SQL/MX Reference Manual
TABLECODE file attribute No See SQL/MP Reference Manual
Tables Yes See SQL/MX Reference Manual
TABLES table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
TEDIT command No
Temporary tables Yes Used internally only in NonStop
SQL/MX.
TIME_FORMAT option Yes See SQL/MX Report Writer Guide
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 16 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments