SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
iii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
Object Naming Statements 2-4
Alias Statements 2-5
Stored Procedure Statements 2-5
Trigger Statements 2-6
ALTER INDEX Statement 2-7
Syntax Description of ALTER INDEX 2-7
Considerations for ALTER INDEX 2-8
Examples of ALTER INDEX 2-8
ALTER SQLMP ALIAS Statement 2-9
Syntax Description of ALTER SQLMP ALIAS 2-9
Considerations for ALTER SQLMP ALIAS 2-9
Examples of ALTER SQLMP ALIAS 2-10
ALTER TABLE Statement 2-11
Syntax Description of ALTER TABLE 2-13
Considerations for ALTER TABLE 2-21
Examples of ALTER TABLE 2-23
ALTER TRIGGER Statement 2-26
Syntax Description of ALTER TRIGGER 2-26
Considerations for ALTER TRIGGER 2-26
BEGIN WORK Statement 2-27
Considerations for BEGIN WORK 2-27
MXCI Examples of BEGIN WORK 2-27
C Examples of BEGIN WORK 2-28
COBOL Examples of BEGIN WORK 2-28
CALL Statement 2-29
Considerations for CALL 2-30
Examples of CALL 2-31
COMMIT WORK Statement 2-32
Considerations for COMMIT WORK 2-32
MXCI Examples of COMMIT WORK 2-32
C Examples of COMMIT WORK 2-33
COBOL Examples of COMMIT WORK 2-34
CONTROL QUERY DEFAULT Statement 2-35
Considerations for CONTROL QUERY DEFAULT 2-35
Examples of CONTROL QUERY DEFAULT 2-36
CONTROL QUERY SHAPE Statement 2-37
Considerations for CONTROL QUERY SHAPE 2-43
Examples of CONTROL QUERY SHAPE 2-43