SQL/MX Comparison Guide for SQL/MP Users

HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
vii
About This Guide
This guide describes SQL differences between NonStop SQL/MP and NonStop
SQL/MX.
This release of NonStop SQL/MX enables applications to use the SQL/MX high-
performance database compiler and executor to access SQL/MP and SQL/MX
databases. You access tables, views, indexes, and catalogs by using SQL/MX Data
Manipulation Language (DML) statements.
Audience
This guide is intended for database administrators and application programmers who
want to:
•
Understand how NonStop SQL/MX differs from NonStop SQL/MP.
•
Write new SQL/MX applications.
•
Write new SQL/MP applications that will be ported to NonStop SQL/MX in the
future.
•
Investigate migrating existing SQL/MP applications to NonStop SQL/MX.
Learning about the features of SQL implemented in NonStop SQL/MX enables you, as
a database administrator or an application programmer, to choose the appropriate
database for your needs. In particular, it is important for those who want to rework
SQL/MP applications to NonStop SQL/MX to begin thinking about specific differences.
Related Documentation
This manual is part of the NonStop SQL/MX library of manuals, which includes:
Introductory Guides
SQL/MX Comparison Guide
for SQL/MP Users
Describes SQL differences between NonStop
SQL/MP and NonStop SQL/MX.
SQL/MX Quick Start Describes basic techniques for using SQL in the
SQL/MX conversational interface (MXCI). Includes
information about installing the sample database.
Reference Manuals
SQL/MX Reference Manual Describes the syntax of SQL/MX statements, MXCI
commands, functions, and other SQL/MX language
elements.
SQL/MX Connectivity
Service Administrative
Command Reference
Describes the SQL/MX administrative command
library (MACL) available with the SQL/MX
conversational interface (MXCI).
DataLoader/MX Reference
Manual
Describes the features and functions of the
DataLoader/MX product, a tool to load SQL/MX
databases.