MX Database and Application Migration Guide

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001

4-1

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 chapter explains how to convert SQL/MP applications to SQL/MX

applications and covers the following topics:



Converting SQL/MP Applications to SQL/MX Applications on page 4-2



Types of SQL/MP Applications to Convert on page 4-6



Steps for Converting SQL/MP Applications to SQL/MX Applications on page 4-15



Modifying the Source Code on page 4-16



Changes to SQL Syntax on page 4-16



Changes to Embedded SQL Constructs on page 4-41



Compiling the Application on page 4-53



Optimizing Query Execution Performance on page 4-59



Moving the Application From Development to Production on page 4-60

SQL/MX Release 3.0 must be installed on your system. For more information, see

Installing SQL/MX

on page 3-3.

Although this chapter explains how to convert SQL/MP applications to NonStop

SQL/MX, you can use the information in this chapter to develop new SQL/MX

applications.