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

7. Migrating SQL/MX Release 1.8 Applications to

SQL/MX Release 2.x

7. Migrating SQL/MX Release 1.8 Applications to SQL/MX

Release 2.x

Planning to Execute SQL/MX Release 1.8 Applications in SQL/MX Release 2.x 7-1

Adapting SQL/MX Release 1.8 Applications to SQL/MX Release 2.x Functionality 7-3

Statement-Level Atomicity: No Automatic Abort Following an Error 7-3

Stable Access 7-4

IEEE Floating-Point Host Variables 7-4

Using INVOKE for Date-Time and Interval Host Variables 7-5

KANJI and KSC5601 Character Data 7-6

SQL/MX Release 1.8 Applications in a Distributed Database Environment 7-7

Recompiling SQL/MX Release 1.8 Applications in SQL/MX Release 2.x 7-7

Changes to Query Optimization and Statistics in SQL/MX Release 2.x 7-7

Converting SQLJ Applications to JDBC/MX 7-8

8. Falling Back to SQL/MX Release 1.8

Preparing to Fall Back From SQL/MX Release 2.x to SQL/MX Release 1.8 8-1

Obtaining the Previous RVU 8-1

Obtaining SQL/MX Release 1.8 8-2

Obtaining Corequisite Independent Products 8-2

Assessing Changes to the Applications and Database in SQL/MX Release

2.x 8-2

Planning to Fall Back Other Nodes in the Network 8-3

Steps for Falling Back From SQL/MX Release 2.x to SQL/MX Release 1.8 8-3

Drop SQL/MX Objects 8-4

Load a Previous RVU 8-5

Install Compatible Versions of Independent Products 8-6

Start TMF 8-6

Install SQL/MX Release 1.8 8-6

Drop Remaining SQL/MX Objects 8-6

Remove the InstallSqlmx Script 8-7

Initialize SQL/MX Release 1.8 (Optional) 8-7

Reconfigure the NonStop ODBC/MX Server and Driver 8-8

Fall Back SQL/MX Release 2.x Applications and User Modules to SQL/MX

Release 1.8 8-8

Managing Module Files and Applications During Fallback From SQL/MX Release

2.x 8-9

Managing Globally Placed Modules and Applications During Fallback 8-9

Managing Locally Placed Module Files and Applications During Fallback 8-10

Converting Locally Placed User Modules to Globally Placed User Modules 8-11