SQL/MX Comparison Guide for SQL/MP Users

Hewlett-Packard Company—523735-003
i
HP NonStop SQL/MX
Comparison Guide for SQL/MP
Users
Index Figures Tables
What’s New in This Manual v
Manual Information v
New and Changed Information v
About This Guide vii
Audience vii
Related Documentation vii
Notation Conventions x
1. Comparing the Differences in the Products
Why Build a New DBMS? 1-1
Frequently Asked Questions About Differences 1-2
What’s New in NonStop SQL/MX? 1-4
Redesigned Optimizer and Executor 1-4
Performance 1-4
Parallel Operations for Scalable High Performance 1-4
Manageability 1-5
ANSI Compatibility 1-5
Other Features 1-6
2. Quick Reference to Differences
3. DML Features
Data Types 3-1
Date-time Data Types 3-1
Interval Data Type 3-2
Selecting FRACTION-Only Interval Columns 3-3
Floating-Point Data Types 3-4
File Types
3-4
Identifiers
3-5
Reserved Words 3-5
Literals 3-5
String Delimiters 3-5