SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-6
Types of SQL/MP Applications to Convert
Parallel Operations on Partitioned Tables
Currently, unlike NonStop SQL/MP, NonStop SQL/MX does not open partitions in
parallel. 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 a SQL/MX Release 3.0 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 4-6

Embedded SQL/MP
program in COBOL
Embedded SQL/MX
program in COBOL
Converting Embedded SQL/MP
Applications to NonStop
SQL/MX on page 4-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 4-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 4-8

SQLCI script MXCI script Converting SQLCI Scripts to
NonStop SQL/MX on page 4-8