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-6
Types of SQL/MP Applications to Convert
Parallel Operations on Partitioned Tables
Currently, NonStop SQL/MX does not open partitions in parallel as NonStop SQL/MP
does. If a table has many partitions, opens takes longer to complete.
ESPs in NonStop SQL/MX are not started in parallel as the ESP Manager does in
NonStop SQL/MP. If a table has many partitions, ESP startup takes longer to complete.
Types of SQL/MP Applications to Convert
Determine which types of SQL/MP applications you want to convert to NonStop
SQL/MX, and see the respective subsections for more information.
Converting Embedded SQL/MP Applications to NonStop
SQL/MX
To convert embedded SQL/MP applications written in C or COBOL to embedded
SQL/MX applications in an SQL/MX Release 2.x environment:
1. Identify the source files being moved.
SQL/MP Application SQL/MX Application For more information...
Statically Compiled
•
Embedded SQL/MP
program in C
Embedded SQL/MX
program in C or C++
Converting Embedded SQL/MP
Applications to NonStop
SQL/MX on page 10-6
•
Embedded SQL/MP
program in COBOL
Embedded SQL/MX
program in COBOL
Converting Embedded SQL/MP
Applications to NonStop
SQL/MX on page 10-6
•
Embedded SQL/MP
program in Pascal
N.A.
•
Embedded SQL/MP
program in TAL
N.A.
Dynamically Compiled
•
ODBC client
application that uses
the NonStop ODBC
driver
ODBC client
application that uses
MXCS
Converting ODBC Client
Applications to NonStop
SQL/MX on page 10-7
•
Java application that
uses the JDBC/MP
type 2 driver
Java application that
uses the JDBC/MX
type 2 or type 4 driver
Converting JDBC/MP
Applications to NonStop
SQL/MX on page 10-8
•
SQLCI script MXCI script Converting SQLCI Scripts to
NonStop SQL/MX on page 10-8