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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
iii
2. SQL/MX Statements
Collations 1-33
ANSI Compliance and SQL/MX Extensions 1-34
Default Settings for ANSI Compliance 1-34
ANSI-Compliant Statements 1-34
Statements That Are SQL/MX Extensions 1-35
ANSI-Compliant Functions 1-36
SQL/MX Error Messages 1-37
2. SQL/MX Statements
Categories 2-1
Data Definition Language (DDL) Statements 2-1
Data Manipulation Language (DML) Statements 2-4
Transaction Control Statements 2-4
Prepared SQL Statements 2-4
Embedded-Only SQL/MX Statements 2-5
Resource Control and Optimization Statements 2-5
Control Statements 2-5
Object Naming Statements 2-7
Alias Statements 2-7
Stored Procedure Statements 2-7
Trigger Statements 2-8
Utilities 2-8
Privileges Required to Execute Utilities 2-9
Checking DDL Locks 2-9
ALTER INDEX Statement 2-11
Syntax Description of ALTER INDEX
2-11
Considerations for ALTER INDEX
2-12
You cannot use ALTER INDEX to change the Guardian name of a partition. To
change the Guardian name of a partition, use the Modify utility with the
rename option. For more information, see Renaming Guardian Location of
Partitions of Tables, Indexes or Sequence Generators. 2-12
Renaming an Index
2-12
Effects on TMF 2-12
Effects on RDF
2-12
Examples of ALTER INDEX
2-13
ALTER SEQUENCE Statement
2-13
Syntax Description of ALTER SEQUENCE
2-15
Considerations for ALTER SEQUENCE 2-16
Authorization Requirements
2-16
Restrictions 2-16