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

ManualsBrandsHP ManualsServerHP NonStop G-Series

HP NonStop SQL/MX Reference Manual—523725-004

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. 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.

Section 8, SQL/MX File

Attributes

Describes SQL/MX file attributes.