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

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-55
Converting Guardian Applications to OSS
Converting Guardian Applications to OSS
Open System Services (OSS) is an open interface through which programs can
interact with the NonStop operating system. OSS coexists with the Guardian
environment on a NonStop system. Several SQL/MX processes and utilities run in the
OSS environment, and most SQL/MX applications are compiled and executed by
default in the OSS environment.
Embedded SQL/MX applications are not restricted to being compiled and executed in
the OSS environment. You can use OSS pass-through commands to compile and
execute embedded SQL/MX applications in the Guardian environment. For more
information, see the
SQL/MX Programming Manual for C and COBOL.
If you plan to move to the OSS environment when converting your SQL/MP
applications to SQL/MX applications, you might need to convert the TACL macros that
compile applications to OSS shell scripts. For more information about migrating
Guardian applications to OSS, see the
Open Systems Services Porting Guide.
Similarity Checks and Automatic Recompilation of Embedded
SQL/MX Applications
If you convert an embedded SQL/MP application to NonStop SQL/MX, be aware of the
differences in how NonStop SQL/MP and NonStop SQL/MX handle similarity checks
and automatic recompilation of the compiled query execution plans.
Program Invalidation
NonStop SQL/MX checks validity on a statement basis and does not mark executables
invalid as NonStop SQL/MP does. In NonStop SQL/MX, if a statement plan becomes
invalid because of a DDL operation, the similarity check fails, and automatic
recompilation of the invalid statement occurs at run time. The recompiled statement
plan is saved in memory and used for the duration of the application executable.
•
Java application that
uses the JDBC/MX
type 2 driver
OSS NonStop Server for Java
Programmer’s Reference
and JDBC Driver for
SQL/MX Programmer’s
Reference
•
Java application that
uses the JDBC/MX
type 4 driver
Depends on the client platform
(The server-side environment is
OSS.)
NonStop Server for Java
Programmer’s Reference
and JDBC Type 4
Programmer’s Reference
•
MXCI script OSS or Guardian (No
compilation is involved.)
SQL/MX Reference Manual
Table 10-14. Development Environments for SQL/MX Applications (page 2 of 2)
SQL/MX Application Development Environment For more information...