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

Migrating SQL/MX Release 1.8 Applications to
SQL/MX Release 2.x
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
7-2
Planning to Execute SQL/MX Release 1.8
Applications in SQL/MX Release 2.x
Table 7-1. Checklist for Migrating SQL/MX Release 1.8 Applications
Application Attributes
Embedded SQL/MX program in C/C++ Embedded SQL/MX program in COBOL ODBC client that uses MXCS Java application that uses JDBC/MX MXCI script SQLJ application
Guidelines for
Migration
•
Does the application rely
on transaction-level
atomicity?
Statement-Level
Atomicity: No Automatic
Abort Following an Error
on page 7-3
•
Do queries in the
application specify STABLE
ACCESS?
Stable Access on
page 7-4
•
Does the application use
floating-point host variables
or query floating-point
columns?
IEEE Floating-Point Host
Variables on page 7-4
•
Does the application use
INVOKE for date-time and
interval host variables?
Using INVOKE for Date-
Time and Interval Host
Variables on page 7-5
•
Does the application query
KANJI or KSC5601
character data?
KANJI and KSC5601
Character Data on
page 7-6
•
Does the application query
database objects on
remote nodes?
SQL/MX Release 1.8
Applications in a
Distributed Database
Environment on page 7-7
•
Does the application use
SQLJ constructs?
Converting SQLJ
Applications to JDBC/MX
on page 7-8