SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
iii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
Control Statements 2-4
Object Naming Statements 2-5
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-8
Syntax Description of ALTER SQLMP ALIAS 2-8
Considerations for ALTER SQLMP ALIAS 2-9
Examples of ALTER SQLMP ALIAS 2-9
ALTER TABLE Statement 2-10
Syntax Description of ALTER TABLE 2-12
Considerations for ALTER TABLE 2-20
Examples of ALTER TABLE 2-22
ALTER TRIGGER Statement 2-25
Syntax Description of ALTER TRIGGER 2-25
Considerations for ALTER TRIGGER 2-25
BEGIN WORK Statement 2-25
Considerations for BEGIN WORK 2-26
MXCI Examples of BEGIN WORK 2-26
C Examples of BEGIN WORK 2-26
COBOL Examples of BEGIN WORK 2-27
CALL Statement 2-27
Considerations for CALL 2-29
Examples of CALL 2-30
COMMIT WORK Statement 2-31
Considerations for COMMIT WORK 2-31
MXCI Examples of COMMIT WORK 2-31
C Examples of COMMIT WORK 2-32
COBOL Examples of COMMIT WORK 2-33
CONTROL QUERY DEFAULT Statement 2-34
Considerations for CONTROL QUERY DEFAULT 2-34
Examples of CONTROL QUERY DEFAULT 2-35
CONTROL QUERY SHAPE Statement 2-36
Considerations for CONTROL QUERY SHAPE 2-43