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