SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-1
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-5
•
Resource Control and Optimization Statements on page 2-5
•
Control Statements on page 2-5
•
Object Naming Statements on page 2-7
•
Alias Statements on page 2-7
•
Stored Procedure Statements on page 2-7
•
Trigger Statements on page 2-8
•
Utilities on page 2-8
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-11
Changes file attributes of an index and renames the
index.
ALTER SEQUENCE Statement
on
page 2-13
Maps an existing alias to a different SQL/MP table.
ALTER TABLE Statement
on
page 2-19
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-48
Alters trigger status.
ALTER SEQUENCE Statement
on
page 2-13
Alters sequence generator attributes.