SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
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-3
•
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
Changes the physical name of an SQL/MP table to
which an existing alias is mapped.
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.
ALTER VIEW Statement
on
page 2-41
Renames a view within the schema.
CREATE CATALOG Statement
on
page 2-69
Creates a catalog on the local node.