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
3
5. Converting SQL/MP Tables to SQL/MX Tables
INSERT Statements 4-22
SELECT Statements
4-23
UPDATE Statements
4-24
Access Options and Isolation Levels
4-24
SQL Functions
4-26
Predicates
4-28
Database Object References
4-31
Reserved Words
4-32
String Literal Delimiters
4-33
Character Sets
4-34
Collations
4-35
Date-Time Data Types and Literals
4-35
Interval Data Types and Literals
4-38
Floating-Point Data Types
4-40
Data Security Language (DSL) Statements
4-40
Data Definition Language (DDL) Statements
4-41
Changes to Embedded SQL Constructs
4-41
Host Variable Declarations
4-42
Indicator Variables
4-44
Embedded SQL Statements
4-45
Dynamic SQL
4-47
Error Handling
4-49
Statistics Area
4-53
Compiling the Application
4-53
Development Environments for SQL/MX Applications
4-54
Converting Guardian Applications to OSS
4-54
Similarity Checks and Automatic Recompilation of Embedded SQL/MX
Applications 4-55
Managing Modules of Embedded SQL/MX Applications
4-57
Optimizing Query Execution Performance
4-59
Setting System Defaults
4-59
Updating Table Statistics
4-59
Displaying and Analyzing Query Execution Plans
4-59
Forcing Query Execution Plans
4-59
Using Row-Value Constructors
4-60
Moving the Application From Development to Production
4-60
Ensuring Optimal Performance in Production
4-60
Steps for Moving an Application to Production
4-61
5. Converting SQL/MP Tables to SQL/MX Tables