SQL/MX 2.x Reference Manual (H06.04+)

HP NonStop SQL/MX Reference Manual—540440-003
xxxv
About This Manual
This manual describes the syntax of SQL language elements—data types,
expressions, functions, identifiers, literals, and predicates—and SQL statements of
NonStop SQL/MX, the NonStop relational database management system based on
ANSI SQL:1999. The manual also includes embedded SQL statements and MXCI
commands.
Audience
This manual is intended for database administrators and application programmers who
are using NonStop SQL/MX through MXCI—the SQL/MX conversational interface—or
as embedded SQL to access databases. To use this product, the reader must be
familiar with structured query language (SQL) and with the American National Standard
Database Language SQL:1999.
Organization
Note. In this manual, SQL language elements, statements, and clauses within statements that
are extensions to the ANSI SQL:1999 standard are noted as SQL/MX extensions.
Section Description
Section 1, Introduction
Introduces NonStop SQL/MX and covers topics such as
entering statements and commands in MXCI, database security,
data consistency and integrity, transaction management,
querying SQL/MP databases, and ANSI compliance and
SQL/MX extensions.
Section 2, SQL/MX
Statements
Describes the SQL statements supported by NonStop SQL/MX.
Section 3, Embedded-
Only SQL/MX Statements
Describes the SQL statements that you embed only in
programs.
Section 4, MXCI
Commands
Describes the MXCI commands that you run only in the
SQL/MX conversational interface (MXCI).
Section 5, SQL/MX
Utilities
Describes utilities that perform such tasks as duplicating files,
importing data, migrating metadata, and populating indexes.
Section 6, SQL/MX
Language Elements
Describes parts of the language, such as database objects, data
types, expressions, identifiers, literals, and predicates, which
occur within the syntax of SQL/MX statements and MXCI
commands.
Section 7, SQL/MX
Clauses
Describes clauses used by SQL/MX statements.