MX Database and Application Migration Guide

Contents

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001

Examples

Figures

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

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

Tables

Table 1-1. Determining Your Business Objectives 1-5

Table 1-2. System Configuration 1-6

Table 1-3. Database Applications 1-7

Table 1-4. Application Execution Environment 1-9

Table 1-5. Development Environment 1-9

Table 1-6. Testing Environment 1-9

Table 1-7. Database 1-10

Table 1-8. Choosing Which Database Applications to Migrate 1-11

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

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

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

Table 2-2. RVUs and Supported SQL/MX Releases 2-6

Table 2-3. Software Version Identifiers for SQL/MX Release 3.0 2-8

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

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

Table 4-3. CONTROL TABLE Directives 4-18

Table 4-4. CONTROL QUERY Directives 4-19

Table 4-5.

SQL/MX and SQL/MP Transaction Control Statements 4-19

Table 4-6.

SQL/MX and SQL/MP DML Statements 4-22

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

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

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

Table 4-10.

Mapping Between Interval Data Types in NonStop SQL/MP and

NonStop SQL/MX 4-39

Table 4-11. SQL/MX and SQL/MP DSL Statements 4-41

Table 4-12. Embedded SQL Statements 4-45

Table 4-13. Mapping SQL/MP SQLCODE to SQL/MX SQLCODE Values 4-49

Table 4-14. Development Environments for SQL/MX Applications 4-54

Table 4-15. Comparison of Similarity Checks Between NonStop SQL/MP and

NonStop SQL/MX 4-56

Table 5-1.

File Attributes in NonStop SQL/MP and NonStop SQL/MX 5-8

Table 5-2. SQL/MP and SQL/MX Constraints 5-10

Table 5-3. Differences Between SQL/MP and SQL/MX Indexes 5-12