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

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
iii
2. SQL/MX Statements
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-4
Resource Control and Optimization Statements 2-5
Control Statements 2-5
Object Naming Statements 2-6
Alias Statements 2-6
Stored Procedure Statements 2-6
Trigger Statements 2-7
ALTER INDEX Statement 2-8
Syntax Description of ALTER INDEX 2-8
Considerations for ALTER INDEX 2-9
Examples of ALTER INDEX 2-10
ALTER SQLMP ALIAS Statement 2-10
Syntax Description of ALTER SQLMP ALIAS 2-10
Considerations for ALTER SQLMP ALIAS 2-11
Examples of ALTER SQLMP ALIAS 2-11
ALTER TABLE Statement 2-12
Syntax Description of ALTER TABLE 2-14
Considerations for ALTER TABLE 2-25
Examples of ALTER TABLE 2-35
ALTER TRIGGER Statement 2-40
Syntax Description of ALTER TRIGGER
2-41
Considerations for ALTER TRIGGER 2-41
ALTER VIEW Statement 2-41
Considerations for ALTER VIEW
2-43
Example of ALTER VIEW
2-43
BEGIN WORK Statement 2-44
Considerations for BEGIN WORK
2-44
MXCI Examples of BEGIN WORK
2-44
C Examples of BEGIN WORK
2-45
COBOL Examples of BEGIN WORK
2-45
CALL Statement 2-45
Considerations for CALL
2-47
Examples of CALL 2-48