SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Contents

HP NonStop SQL/MX Database and Application Migration Guide—540435-005

9. Preparing to Migrate From NonStop SQL/MP to

NonStop SQL/MX

Part III. Migrating From NonStop SQL/MP to

NonStop SQL/MX

9. Preparing to Migrate From NonStop SQL/MP to NonStop

SQL/MX

Using NonStop SQL/MX and NonStop SQL/MP Together 9-1

Meeting System Hardware Requirements 9-1

Migrating From K-Series to S-Series Systems or NS-Series Systems 9-2

Migrating From S-Series Systems to NS-Series Systems 9-2

Meeting Operating System Requirements 9-2

Planning for Performance and Capacity 9-2

Planning for Fallback 9-3

Planning New Feature Implementation 9-3

Keeping SQL/MP Applications, Database Objects, and Metadata 9-3

Installing the Latest Supported Version of SQL/MX Release 2.x 9-4

Installing Corequisite Independent Products 9-4

Preparing to Migrate SQL/MP Applications 9-5

Preparing to Migrate SQL/MP Database Objects 9-5

10. Converting SQL/MP Applications to SQL/MX Applications

Why Convert SQL/MP Applications to SQL/MX Applications? 10-2

ANSI Compliance and Portability 10-2

New Functionality in NonStop SQL/MX 10-2

Ability to Query SQL/MX Database Objects 10-4

Redesigned Optimizer and Executor 10-4

Parallel Operations for Scalable High Performance 10-5

Reasons for Keeping SQL/MP Applications 10-5

Types of SQL/MP Applications to Convert 10-6

Converting Embedded SQL/MP Applications to NonStop SQL/MX 10-6

Converting ODBC Client Applications to NonStop SQL/MX 10-7

Converting JDBC/MP Applications to NonStop SQL/MX 10-8

Converting SQLCI Scripts to NonStop SQL/MX 10-8

Steps for Converting SQL/MP Applications to SQL/MX Applications 10-15

Modifying the Source Code 10-16

Changes to SQL Syntax 10-16

Data Control Language (DCL) Statements 10-17

Transaction Control Statements 10-19

Data Manipulation Language (DML) Statements 10-21