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

About This Manual
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xxxv
Audience
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, ODBC, or JDBC applications to access databases. To use this
product, the reader must be familiar with Structured Query Language (SQL) and with
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.