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-2
Converting SQL/MP Applications to SQL/MX
Applications
Converting SQL/MP Applications to SQL/MX
Applications
HP recommends that you create new applications using NonStop SQL/MX and
continue using SQL/MP applications for risk-averse situations. Creating new SQL/MX
applications or converting existing SQL/MP applications to NonStop SQL/MX offers the
following advantages:

ANSI Compliance and Portability on page 4-2

New Functionality in NonStop SQL/MX on page 4-2

Ability to Query SQL/MX Database Objects on page 4-4

Redesigned Optimizer and Executor on page 4-4

Parallel Operations for Scalable High Performance on page 4-5
Before converting a SQL/MP application to NonStop SQL/MX, evaluate the Reasons
for Keeping SQL/MP Applications on page 4-5.
ANSI Compliance and Portability
NonStop SQL/MX is open, portable, and, most importantly, uses the American National
Standards Institute (ANSI) version of SQL.
NonStop SQL/MX is based on ANSI SQL:1999 and includes support for features from
higher levels of the standard. Core SQL:1999 contains all of Entry SQL-92, plus much
of Intermediate SQL-92, some of Full SQL-92, and a few new SQL:1999 features.
NonStop SQL/MP is based on the SQL-89 standard, which is far less complete for
business-critical applications than SQL:1999.
Applications with SQL statements that adhere to the SQL:1999 standard can be ported
to run against a variety of database management systems, including NonStop
SQL/MX. If you are familiar with other SQL:1999-compliant database management
systems, you can easily apply your skills to applications for NonStop SQL/MX.
For details about how SQL/MX features comply with ANSI standards, see ANSI
Compliance and SQL/MX Extensions in the
SQL/MX Reference Manual.
New Functionality in NonStop SQL/MX
NonStop SQL/MX offers many useful features that NonStop SQL/MP does not include.
They are as follows:

Publish/Subscribe on page 4-3

Data Mining on page 4-3

Compound Statements and Rowsets on page 4-3

Stored Procedures in Java on page 4-4