SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
vii
2. SQL/MX Statements
2-214
INITIALIZE SQL Statement 2-215
Considerations for INITIALIZE SQL 2-215
Examples of INITIALIZE SQL 2-215
INSERT Statement 2-216
Considerations for INSERT 2-221
Considerations for self-referencing inserts 2-224
MXCI Examples of INSERT 2-226
C Examples of INSERT 2-231
COBOL Examples of INSERT 2-231
LOCK TABLE Statement 2-232
Considerations for LOCK TABLE 2-232
Examples of LOCK TABLE 2-233
PREPARE Statement 2-235
Considerations for PREPARE 2-236
MXCI Examples of PREPARE 2-237
C Examples of PREPARE 2-238
COBOL Examples of PREPARE 2-239
REGISTER CATALOG Statement 2-240
Considerations for REGISTER CATALOG 2-240
Examples of REGISTER CATALOG 2-240
REVOKE Statement 2-242
Syntax Description of REVOKE 2-242
Considerations for REVOKE 2-244
Examples of REVOKE 2-244
REVOKE CREATE CATALOG Statement 2-245
Considerations for REVOKE CREATE CATALOG
2-245
Examples for REVOKE CREATE CATALOG 2-245
REVOKE CREATE SCHEMA Statement 2-246
Considerations for REVOKE CREATE SCHEMA
2-246
Example for REVOKE CREATE SCHEMA
2-246
REVOKE EXECUTE Statement 2-247
Considerations for REVOKE EXECUTE
2-248
Examples of REVOKE EXECUTE
2-249
REVOKE SECURITY_ADMIN Statement
2-249
Considerations for REVOKE SECURITY_ADMIN
2-250
Examples of REVOKE SECURITY_ADMIN 2-250
ROLLBACK WORK Statement
2-251
Considerations for ROLLBACK WORK 2-251