SQL/MX 2.x Reference Manual (H06.04+)

HP NonStop SQL/MX Reference Manual—540440-003
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-3
•
Prepared SQL Statements on page 2-3
•
Embedded-Only SQL/MX Statements on page 2-4
•
Resource Control and Optimization Statements on page 2-4
•
Control Statements on page 2-4
•
Object Naming Statements on page 2-5
•
Alias Statements on page 2-5
•
Stored Procedure Statements on page 2-5
•
Trigger Statements on page 2-6
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-7
Changes file attributes of an index.
ALTER SQLMP ALIAS Statement
on
page 2-8
Changes the physical name of an SQL/MP table to
which an existing alias is mapped.
ALTER TABLE Statement
on
page 2-10
Adds a constraint or column to a table, drops existing
constraints, or changes file attributes of a table.
ALTER TRIGGER Statement
on
page 2-24
Alters trigger status.
CREATE CATALOG Statement
on
page 2-50
Creates a catalog on the local node.
CREATE INDEX Statement
on
page 2-52
Creates an index on a table.
CREATE PROCEDURE Statement
on page 2-59
Defines an existing Java method as an SPJ and
registers it in NonStop SQL/MX.
CREATE SCHEMA Statement
on
page 2-66
Creates a schema.