SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
iii
2. SQL/MX Statements (continued)
2. SQL/MX Statements (continued)
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-24
Syntax Description of ALTER TRIGGER 2-24
Considerations for ALTER TRIGGER 2-25
BEGIN WORK Statement 2-25
Considerations for BEGIN WORK 2-25
MXCI Examples of BEGIN WORK 2-25
C Examples of BEGIN WORK 2-26
COBOL Examples of BEGIN WORK 2-26
CALL Statement 2-27
Considerations for CALL 2-28
Examples of CALL 2-29
COMMIT WORK Statement 2-30
Considerations for COMMIT WORK 2-30
MXCI Examples of COMMIT WORK 2-30
C Examples of COMMIT WORK 2-31
COBOL Examples of COMMIT WORK 2-32
CONTROL QUERY DEFAULT Statement 2-33
Considerations for CONTROL QUERY DEFAULT 2-33
Examples of CONTROL QUERY DEFAULT 2-34
CONTROL QUERY SHAPE Statement 2-35
Considerations for CONTROL QUERY SHAPE 2-41
Examples of CONTROL QUERY SHAPE 2-41