NonStop NS-Series Database Migration Guide

Migrating SQL/MP, SQL/MX, and Enscribe
Applications
HP Integrity NonStop NS-Series Database Migration Guide—540469-001
4-9
SQL Compilation
To ensure proper resolution of DEFINE names, you do not need to SQL compile each
program that uses DEFINEs because these programs use the run-time DEFINEs that
you set in the execution environment of the TNS/E system. However, to ensure optimal
query execution plans and prevent automatic recompilation, explicitly SQL compile all
embedded SQL programs on the TNS/E system. For more information, see SQL
Compilation on page 4-9.
For more information about database object names, see one or more of these
manuals:
•
SQL/MX Reference Manual
•
SQL/MP Reference Manual
For information about object name resolution, see one or more of these manuals:
•
SQL/MX Programming Manual for C and COBOL
•
SQL/MX Installation and Management Guide
•
SQL/MP Installation and Management Guide
SQL Compilation
After you move and recompile embedded SQL/MP and SQL/MX programs on an
Integrity NonStop NS-series (or any new) system, you must SQL compile the programs
to ensure optimal query execution plans. For more information, see one or more of
these references:
•
SQL/MX Database and Application Migration Guide
•
SQL/MX Installation and Management Guide
•
SQL/MX Programming Manual for C and COBOL (SQL/MX C/C++ and COBOL
program compilation)
•
SQL/MP Programming Manual for C (SQL/MP C program compilation)
•
SQL Supplement for H-Series Servers (SQL/MP COBOL program compilation)
Java Applications That Use JDBC/MX or
JDBC/MP
Java applications are interpreted by the Java virtual machine (JVM) and, therefore, are
binary portable on TNS/E systems. Typically, you do not need to recompile Java
applications after you move them to a new system. The migrated Java applications
should run without modification and recompilation. However, be aware of these
migration issues for Java applications that use JDBC/MX or JDBC/MP:
•
Object Name References on page 4-10
•
Java Native Interface (JNI) Changes on page 4-10