SQL/MP to SQL/MX Database and Application Migration Guide

Contents
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
iii
4. Converting SQL/MP Applications to SQL/MX
Applications
Converting JDBC/MP Applications to NonStop SQL/MX 4-8
Converting SQLCI Scripts to NonStop SQL/MX 4-8
Steps for Converting SQL/MP Applications to SQL/MX Applications 4-15
Modifying the Source Code 4-16
Changes to SQL Syntax 4-16
Data Control Language (DCL) Statements 4-17
Transaction Control Statements 4-19
Data Manipulation Language (DML) Statements 4-21
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-54
Development Environments for SQL/MX Applications 4-54
Converting Guardian Applications to OSS 4-55
Similarity Checks and Automatic Recompilation of Embedded SQL/MX
Applications 4-55
Managing Modules of Embedded SQL/MX Applications 4-58
Optimizing Query Execution Performance 4-59
Setting System Defaults 4-59