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

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-1
Categories
2 SQL/MX Statements
This section describes the syntax and semantics of NonStop SQL/MX statements that
you can run in MXCI or embed in programs written in C, C++, COBOL, or Java. For
more information on which SQL/MX statements you can embed in a particular
language, see the SQL/MX Programming Manual for C and COBOL.
Categories
The statements are categorized according to their functionality:

Data Definition Language (DDL) Statements on page 2-1

Data Manipulation Language (DML) Statements on page 2-4

Transaction Control Statements on page 2-4

Prepared SQL Statements on page 2-4

Embedded-Only SQL/MX Statements on page 2-4

Resource Control and Optimization Statements on page 2-5

Control Statements on page 2-5

Object Naming Statements on page 2-6

Alias Statements on page 2-6

Stored Procedure Statements on page 2-6

Trigger Statements on page 2-7
Data Definition Language (DDL) Statements
Use these DDL statements to define, delete, or modify the definition of an SQL/MX
catalog, schema, or object, or the authorization to use an object.
ALTER INDEX Statement on
page 2-8
Changes file attributes of an index and renames the
index.
ALTER SQLMP ALIAS Statement
on
page 2-10
Maps an existing alias to a different SQL/MP table.
ALTER TABLE Statement
on
page 2-12
Adds a constraint or column to a table, drops existing
constraints, changes file attributes of a table, or
renames a table.
ALTER TRIGGER Statement
on
page 2-40
Alters trigger status.