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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xiv
2. SQL/MX Statements
Syntax Description of RECOVER 2-310
Considerations for RECOVER 2-311
Examples of RECOVER 2-311
RECOVER SCHEMA Operation 2-311
Considerations for RECOVER SCHEMA 2-312
Authorization and Availability Requirements 2-312
DDL Locks 2-312
Examples of RECOVER SCHEMA 2-312
REGISTER CATALOG Statement 2-314
Considerations for REGISTER CATALOG 2-314
Authorization and Availability Requirements 2-314
Examples of REGISTER CATALOG 2-314
REVOKE Statement 2-316
Syntax Description of REVOKE 2-316
Considerations for REVOKE 2-318
Authorization Requirements 2-318
Examples of REVOKE 2-319
REVOKE CREATE CATALOG Statement 2-319
Considerations for REVOKE CREATE CATALOG 2-319
Examples for REVOKE CREATE CATALOG 2-320
REVOKE CREATE SCHEMA Statement 2-320
Considerations for REVOKE CREATE SCHEMA 2-320
Example for REVOKE CREATE SCHEMA 2-321
REVOKE EXECUTE Statement 2-322
Considerations for REVOKE EXECUTE 2-323
Authorization and Availability Requirements 2-323
Examples of REVOKE EXECUTE
2-324
REVOKE SECURITY_ADMIN Statement 2-325
Considerations for REVOKE SECURITY_ADMIN 2-325
Authorization Requirements
2-325
Metadata Version Requirements
2-325
Examples of REVOKE SECURITY_ADMIN 2-325
ROLLBACK WORK Statement
2-327
Considerations for ROLLBACK WORK
2-327
Begin and End a Transaction
2-327
MXCI Examples of ROLLBACK WORK
2-327
C Examples of ROLLBACK WORK 2-328
COBOL Examples of ROLLBACK WORK
2-328
SELECT Statement 2-329