SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Introduction
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
1-1
SQL/MX Language
1 Introduction
NonStop SQL/MX allows you to use SQL/MX DML statements, which comply closely to
ANSI SQL:1999, to access SQL/MP and SQL/MX databases.
This introduction describes:

SQL/MX Language on page 1-1

MXCI SQL/MX Conversational Interface on page 1-2

Security on page 1-6

Data Consistency and Access Options on page 1-9

Database Integrity and Locking on page 1-12

Transaction Management on page 1-14

Partition Management on page 1-25

Internationalization on page 1-25

Using NonStop SQL/MX to Access SQL/MP Databases on page 1-25

ANSI Compliance and SQL/MX Extensions on page 1-34

SQL/MX Error Messages on page 1-37
Other sections of this manual describe the syntax and semantics of individual
statements, commands, and language elements.
SQL/MX Language
The SQL/MX language consists of statements, commands, and other language
elements that you can use to access SQL/MP and SQL/MX databases. For more
information on the SQL/MP language, see the SQL/MP Reference Manual.
You can run SQL/MX statements from the SQL/MX conversational interface, MXCI, or
embed SQL/MX statements in programs written in C, C++, COBOL, or Java. For more
information on MXCI, see MXCI SQL/MX Conversational Interface
on page 1-2. For
descriptions of individual SQL/MX statements, see Section 2, SQL/MX Statements
.
Some SQL/MX statements can be used only within embedded SQL programs and
cannot be run in an MXCI session. For descriptions of these statements, see
Section 3, Embedded-Only SQL/MX Statements
. For more information on embedding
SQL/MX statements in programs, see the SQL/MX Programming Guide for C and
COBOL.