SQL/MX Comparison Guide for SQL/MP Users

Contents
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
iii
5. Optimizer and Executor
Embedded SQL Statements 4-4
EXECUTE Statement 4-5
Updatable Cursors 4-6
FETCH Statement 4-6
Positioned UPDATE Statement 4-6
Dynamic SQL 4-6
Descriptor Area 4-7
Error Handling 4-8
Format of Error Codes 4-8
WHENEVER Declarative 4-9
Diagnostics Area 4-9
Statistics Area 4-10
Program Development 4-10
SQL/MP Compiler 4-10
SQL/MX Compiler 4-11
Stored Procedures in Java 4-13
SQL/MP Stored Procedures 4-13
SQL/MX Stored Procedures 4-13
Similarity Checks and Automatic Recompilation 4-13
5. Optimizer and Executor
Optimizer 5-1
Executor 5-3
SQL/MP Iterator Model 5-4
SQL/MX Task Model 5-5
Ways to Influence the Query Execution Plan 5-7
Default Settings 5-7
EXPLAIN Features 5-8
Forcing Query Execution Plans 5-8
Statistics 5-9
6. Data Definition Language (DDL) Differences
SQL Statements 6-1
Database Object Names 6-1
ANSI Names 6-1
Organization of Catalogs and Schemas 6-2
SQL/MX Catalogs 6-2
SQL/MP Catalogs 6-2
Metadata 6-3