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-17
TIME data type Yes See Section 3, DML Features and
SQL/MX Reference Manual
TIMESTAMP data type Yes See Section 3, DML Features and
SQL/MX Reference Manual
TMF transactions Yes See Transaction Management
Facility (TMF) Introduction
TOTAL command No
TRANSID table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
TRIM function Yes See SQL/MX Reference Manual
UNDERLINE_CHAR option Yes See SQL/MX Report Writer Guide
UNLOCK TABLE statement Yes See SQL/MX Reference Manual
UPDATE statement Yes See SQL/MX Reference Manual and
SQL/MX Programming Guide for C
and COBOL
UPDATE STATISTICS
statement
Changed See Section 5, Optimizer and
Executor, SQL/MX Query Guide,
and SQL/MX Reference Manual
UPGRADE CATALOG
command
No
UPGRADE SYSTEM
CATALOG command
No
UPSHIFT function Yes See SQL/MX Reference Manual
USAGES table Changed Metadata tables are implemented
differently. See SQL/MX Reference
Manual
User-defined keys Yes See SQL/MX Reference Manual
Utilities Changed See Section 7, Utility Differences
VARCHAR_WIDTH option Yes See SQL/MX Report Writer Guide
VERIFIEDWRITES file
attribute
No
VERIFY command Yes Replaced by mxtool VERIFY
command
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 17 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments