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

viii

Figures

Figure 1-1. Coexistence of NonStop SQL/MP and NonStop SQL/MX 1-4

Figure 1-2. Migrating SQL/MP Applications to SQL/MX Applications 1-4

Figure 1-3. Migrating SQL/MP Database Objects to SQL/MX Database

Objects 1-5

Tables

Table 1-1. Choosing Phased Migration or Rapid Migration 1-6

Table 1-2. Risks of Different Migration Paths 1-8

Table 1-3. Determining Your Business Objectives 1-9

Table 1-4. System Configuration 1-11

Table 1-5. Database Applications 1-12

Table 1-6. Application Execution Environment 1-13

Table 1-7. Development Environment 1-13

Table 1-8. Testing Environment 1-14

Table 1-9. Database 1-14

Table 1-10. Choosing Which Database Applications to Migrate 1-15

Table 1-11. Choosing Which Database Objects to Migrate 1-16

Table 1-12. Planning the New Application and Database Environment 1-17

Table 2-1. SQL/MX Releases on Systems Running G-Series RVUs 2-2

Table 2-2. SQL/MX Releases on Systems Running H-Series RVUs 2-3

Table 2-3. RVUs and Supported SQL/MX Releases 2-7

Table 2-4. Can an SQL/MX Product Version on One System Interoperate With an

SQL/MX Product Version on Another System? 2-8

Table 2-5. Software Version Identifiers for SQL/MX Release 2.x 2-10

Table 6-1. Source and Destination Metadata Tables for Metadata Migration 6-3

Table 7-1. Checklist for Migrating SQL/MX Release 1.8 Applications 7-2

Table 10-1. SQLCI Commands and MXCI Commands 10-9

Table 10-2. SQL/MX and SQL/MP DCL Statements 10-17

Table 10-3. CONTROL TABLE Directives 10-18

Table 10-4. CONTROL QUERY Directives 10-19

Table 10-5. SQL/MX and SQL/MP Transaction Control Statements 10-19

Table 10-6. SQL/MX and SQL/MP DML Statements 10-22

Table 10-7. SQL/MX and SQL/MP Functions 10-26

Table 10-8. SQL/MX and SQL/MP Predicates 10-28

Table 10-9. SQL/MX Support for SQL/MP DATETIME Literals 10-37

Table 10-10. Mapping Between Interval Data Types in NonStop SQL/MP and

NonStop SQL/MX 10-39