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

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-2
Why Convert SQL/MP Applications to SQL/MX
Applications?
Why Convert 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 has
several advantages:
•
ANSI Compliance and Portability on page 10-2
•
New Functionality in NonStop SQL/MX on page 10-2
•
Ability to Query SQL/MX Database Objects on page 10-4
•
Redesigned Optimizer and Executor on page 10-4
•
Parallel Operations for Scalable High Performance on page 10-5
Before converting an SQL/MP application to NonStop SQL/MX, be aware of the
Reasons for Keeping SQL/MP Applications
on page 10-5.
ANSI Compliance and Portability
NonStop SQL/MX is open, portable, and, most importantly, uses an industry standard:
the American National Standards Institute (ANSI) version of SQL.
SQL/MX Release 2.x 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 the
SQL/MX
Reference Manual.
New Functionality in NonStop SQL/MX
NonStop SQL/MX has many useful features that NonStop SQL/MP does not have.
These features include:
•
Publish/Subscribe on page 10-3
•
Data Mining on page 10-3
•
Compound Statements and Rowsets on page 10-3
•
Stored Procedures in Java on page 10-4