SQL/MP to SQL/MX Database and Application Migration Guide

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
2
3. Preparing to Migrate From NonStop SQL/MP to
NonStop SQL/MX
SQL/MX Database Object Versions 2-8
SQL/MX Query Plan and Module Versions
2-10
Interoperability Across Schema Versions
2-11
2-11
3. Preparing to Migrate From NonStop SQL/MP to NonStop
SQL/MX
Using NonStop SQL/MX and NonStop SQL/MP Together 3-1
Meeting System Hardware Requirements
3-1
Migrating From S-Series Systems to NS-Series Systems
3-2
Meeting Operating System Requirements
3-2
Planning for Performance and Capacity
3-2
Planning for Fallback
3-3
Planning New Feature Implementatio
n 3-3
Keeping SQL/MP Applications, Database Objects, and Metadata
3-3
Installing
SQL/MX 3-3
Installing Corequisite Independent Products
3-4
Preparing to Migrate SQL/MP Applications
3-4
Preparing to Migrate SQL/MP Database Objects
3-4
4. Converting SQL/MP Applications to SQL/MX Applications
Converting SQL/MP Applications to SQL/MX Applications 4-2
ANSI Compliance and Portability
4-2
New Functionality in NonStop SQL/MX
4-2
Ability to Query SQL/MX Database Objects
4-4
Redesigned Optimizer and Executor
4-4
Parallel Operations for Scalable High Performance
4-5
Reasons for Keeping SQL/MP Applications
4-5
Types of SQL/MP Applications to Convert
4-6
Converting Embedded SQL/MP Applications to NonStop SQL/MX
4-6
Converting ODBC Client Applications to NonStop SQL/MX
4-7
Converting JDBC/MP Applications to NonStop SQL/MX
4-8
Converting SQLCI Scripts to NonStop SQL/MX
4-8
Steps for Converting SQL/MP Applications to SQL/MX Applications
4-15
Modifying the Source Code
4-16
Changes to SQL Syntax
4-16
Data Control Language (DCL) Statements
4-17
Transaction Control Statements
4-19
Data Manipulation Language (DML) Statements
4-21