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
11-1
11
Converting an SQL/MP Database to
SQL/MX Tables
This section explains how to convert SQL/MP database objects to SQL/MX database
objects and covers these topics:
•
Why Convert SQL/MP Tables to SQL/MX Tables? on page 11-1
•
Differences Between SQL/MP and SQL/MX Databases on page 11-4
•
SQL/MX DDL Statements and Utilities on page 11-14
•
Steps for Converting an SQL/MP Database to SQL/MX Tables on page 11-21
•
Migrating Data From an SQL/MP Database to an SQL/MX Database on
page 11-22
•
Updating Table Statistics on page 11-26
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 database objects to NonStop
SQL/MX, you can use the information in this section to help you create new SQL/MX
database objects.
Why Convert SQL/MP Tables to SQL/MX
Tables?
In risk-averse situations, HP recommends that you continue using SQL/MP database
objects and create new SQL/MX database objects for new application features.
Creating new SQL/MX database objects or converting existing SQL/MP database
objects to NonStop SQL/MX has several advantages:
•
ANSI Compliance on page 11-2
•
New Functionality in NonStop SQL/MX on page 11-2
•
Enabling SQL/MX Applications to Access Specific Tables on page 11-2
•
Size of the Database Object on page 11-3
Note. To create SQL/MX database objects, you must purchase and install the SQL/MX DDL
license, product T0394. Without this product, you cannot create SQL/MX database objects. If
you try to create SQL/MX database objects without the DDL license, NonStop SQL/MX returns
an error message informing you that the system is not licensed.