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

HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-1
10
Converting SQL/MP Applications to
SQL/MX Applications
SQL/MP applications use SQL/MP syntax, are SQL-compiled using SQLCOMP, and
can query only SQL/MP database objects. SQL/MX applications use SQL/MX syntax,
are SQL-compiled using MXCMP, and can query SQL/MP and SQL/MX database
objects. This section explains how to convert SQL/MP applications to SQL/MX
applications and covers these topics:
•
Why Convert SQL/MP Applications to SQL/MX Applications? on page 10-2
•
Types of SQL/MP Applications to Convert on page 10-6
•
Steps for Converting SQL/MP Applications to SQL/MX Applications on page 10-15
•
Modifying the Source Code on page 10-16
°
Changes to SQL Syntax on page 10-16
°
Changes to Embedded SQL Constructs on page 10-41
•
Compiling the Application on page 10-54
•
Optimizing Query Execution Performance on page 10-59
•
Moving the Application From Development to Production on page 10-60
The instructions in this section assume that SQL/MX Release 2.x is already installed
on your system. For more information, see Installing the Latest Supported Version of
SQL/MX Release 2.x on page 9-4.
Although this section explains how to convert SQL/MP applications to NonStop
SQL/MX, you can use the information in this section to help you develop new SQL/MX
applications.