SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
v
2. SQL/MX Statements
Authorization and Availability Requirements 2-48
ALTER VIEW Statement 2-49
Considerations for ALTER VIEW 2-50
Authorization and Availability Requirements 2-50
Renaming a View 2-50
Similarity Check 2-50
Effects on TMF 2-50
Example of ALTER VIEW 2-50
BEGIN WORK Statement 2-52
Considerations for BEGIN WORK 2-52
Effect on Audited Tables 2-52
Effect on Nonaudited Tables 2-52
MXCI Examples of BEGIN WORK 2-52
C Examples of BEGIN WORK 2-53
COBOL Examples of BEGIN WORK 2-53
CALL Statement 2-54
Considerations for CALL 2-55
Usage Restrictions 2-55
Required Privileges 2-55
Input Parameter Arguments 2-55
Output Parameter Arguments 2-55
Data Conversion of Parameter Arguments 2-55
Null Input and Output 2-56
Transaction Semantics 2-56
Examples of CALL 2-56
COMMIT WORK Statement 2-57
Considerations for COMMIT WORK
2-57
Begin and End a Transaction 2-57
Effect of Constraints 2-57
MXCI Examples of COMMIT WORK
2-57
C Examples of COMMIT WORK
2-58
COBOL Examples of COMMIT WORK 2-59
CONTROL QUERY DEFAULT Statement
2-60
Considerations for CONTROL QUERY DEFAULT
2-60
Scope of CONTROL QUERY DEFAULT
2-60
Relationship to CONTROL TABLE
2-61
Examples of CONTROL QUERY DEFAULT 2-61
CONTROL QUERY SHAPE Statement
2-62
Considerations for CONTROL QUERY SHAPE 2-69