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
1
Tables
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
Table 5-4.
Index Table Attributes in NonStop SQL/MP and NonStop
SQL/MX 5-12
Table 5-5.
SQL/MP and SQL/MX DDL Statements 5-14
Table 5-6.
Comparing SQL/MP Utilities With SQL/MX Utilities 5-16
Table 5-7.
New SQL/MX Utilities 5-19