SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

HP NonStop SQL/MX Reference Manual—523725-004
1-1
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-5
•
Data Consistency and Access Options on page 1-6
•
Database Integrity and Locking on page 1-9
•
Transaction Management on page 1-11
•
Partition Management on page 1-21
•
Internationalization on page 1-21
•
Using NonStop SQL/MX to Access SQL/MP Databases on page 1-21
•
ANSI Compliance and SQL/MX Extensions on page 1-31
•
SQL/MX Error Messages on page 1-34
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 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 information on embedding
SQL/MX statements in programs, see the SQL/MX Programming Guide for C and
COBOL or the SQL/MX Programming Manual for Java.
MXCI commands are SQL/MX extensions that typically affect attributes of an MXCI
session. These commands can be run only in MXCI, with a few exceptions. For more
information, see Section 4, MXCI Commands.
SQL/MX language elements are part of statements and commands and include data
types, expressions, functions, identifiers, literals, and predicates. For more information,
see Section 6, SQL/MX Language Elements. For information on specific functions and
expressions, see Section 9, SQL/MX Functions and Expressions.