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

HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-1
5
Converting SQL/MP Tables to
SQL/MX Tables
This chapter explains how to convert SQL/MP database objects to SQL/MX database
objects and covers these topics:

Converting SQL/MP Tables to SQL/MX Tables on page 5-1

Differences Between SQL/MP and SQL/MX Databases on page 5-4

SQL/MX DDL Statements and Utilities on page 5-14

Steps for Converting a SQL/MP Database to SQL/MX Tables on page 5-20

Migrating Data From a SQL/MP Database to a SQL/MX Database on page 5-21

Updating Table Statistics on page 5-25
It is assumed that SQL/MX Release 3.0 is already installed on your system. For more
information, see Installing SQL/MX
on page 3-3.
Although this chapter explains how to convert SQL/MP database objects to NonStop
SQL/MX, you can use the information in this chapter to create new SQL/MX database
objects.
Converting 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 5-2

New Functionality in NonStop SQL/MX on page 5-2

Enabling SQL/MX Applications to Access Specific Tables on page 5-2

Size of the Database Object on page 5-3
Before converting a SQL/MP database object to NonStop SQL/MX, be aware of the
Reasons for Keeping SQL/MP Tables
on page 5-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.