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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
viii
2. SQL/MX Statements
Restrictions on Triggers 2-148
Recompilation and Triggers 2-149
Triggers and Primary Keys 2-149
Rowsets 2-150
Examples of CREATE TRIGGER 2-150
Before and After Triggers 2-150
Rowsets and Triggers 2-152
Stored Procedures and Triggers 2-152
CREATE VIEW Statement 2-153
Syntax Description of CREATE VIEW 2-155
Considerations for CREATE VIEW 2-157
VIEW SIMILARITY CHECK 2-157
Restrictions for Similarity Check 2-158
Reserved View Names 2-158
Effect of Adding a Column on View Definitions 2-158
Authorization and Availability Requirements 2-158
Updatable and Non-Updatable Views 2-158
Examples of CREATE VIEW 2-159
DELETE Statement 2-161
Considerations for DELETE 2-165
Multi Commit Delete 2-165
Restrictions 2-166
Authorization Requirements 2-167
Transaction Initiation and Termination 2-167
Isolation Levels of Transactions and Access Options of Statements 2-167
Audited and Nonaudited Tables 2-168
SET ON ROLLBACK Considerations
2-168
SET ON ROLLBACK Restrictions 2-168
MXCI Examples of DELETE 2-168
C Examples of DELETE
2-171
COBOL Examples of DELETE
2-171
Publish/Subscribe Examples of DELETE 2-172
DOWNGRADE Utility
2-174
Considerations for DOWNGRADE
2-175
Modes of Operation for DOWNGRADE
2-175
Command Output for DOWNGRADE
2-175
Error Conditions 2-176
Recovery of a Failed DOWNGRADE Utility
2-176
Error Conditions 2-177