SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

HP NonStop SQL/MX Database and Application Migration Guide—540435-005
7-1
7
Migrating SQL/MX Release 1.8
Applications to SQL/MX Release 2.x
After you migrate to SQL/MX Release 2.x, SQL/MX Release 1.8 applications should
continue to query SQL/MP database objects on the SQL/MX Release 2.x system and
should not require recompilation. However, some SQL/MX applications that were
compiled under SQL/MX Release 1.8 might require changes to the source code or
might require recompilation.
To migrate SQL/MX Release 1.8 applications to SQL/MX Release 2.x, see:
•
Planning to Execute SQL/MX Release 1.8 Applications in SQL/MX Release 2.x on
page 7-1
•
Adapting SQL/MX Release 1.8 Applications to SQL/MX Release 2.x Functionality
on page 7-3
•
SQL/MX Release 1.8 Applications in a Distributed Database Environment on
page 7-7
•
Recompiling SQL/MX Release 1.8 Applications in SQL/MX Release 2.x on
page 7-7
•
Changes to Query Optimization and Statistics in SQL/MX Release 2.x on page 7-7
•
Converting SQLJ Applications to JDBC/MX on page 7-8
Planning to Execute SQL/MX Release 1.8
Applications in SQL/MX Release 2.x
Before executing SQL/MX Release 1.8 applications in an SQL/MX Release 2.x
environment, use the checklist in Table 7-1
on page 7-2 to determine what changes, if
any, are necessary for your applications and to determine if recompilation is required.
The checklist contains links to guidelines that will help you determine:
•
Effect of new SQL/MX Release 2.x features on dynamic applications
•
Consequences of not recompiling certain SQL/MX Release 1.8 applications
•
Possible issues concerning automatic recompilation of embedded SQL/MX
Release 1.8 applications