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

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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-3
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-36
ALTER TRIGGER Statement 2-45
Syntax Description of ALTER TRIGGER
2-45
Considerations for ALTER TRIGGER 2-46
ALTER VIEW Statement 2-46
Considerations for ALTER VIEW
2-47
Example of ALTER VIEW
2-47
BEGIN WORK Statement 2-47
Considerations for BEGIN WORK
2-48
MXCI Examples of BEGIN WORK
2-48
C Examples of BEGIN WORK
2-48
COBOL Examples of BEGIN WORK
2-49
CALL Statement 2-49
Considerations for CALL
2-50
Examples of CALL 2-52