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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xii
2. SQL/MX Statements
Considerations for GRANT EXECUTE 2-246
Authorization and Availability Requirements 2-246
Security Considerations 2-247
Examples of GRANT EXECUTE 2-247
GRANT SECURITY_ADMIN Statement 2-248
Considerations for GRANT SECURITY_ADMIN 2-248
Authorization Requirements 2-248
Security Considerations 2-248
Metadata Version Requirements 2-249
Examples of GRANT SECURITY_ADMIN 2-249
2-249
INITIALIZE SQL Statement 2-250
Considerations for INITIALIZE SQL 2-250
Authorization and Availability Requirements 2-250
Examples of INITIALIZE SQL 2-250
INSERT Statement 2-251
Considerations for INSERT 2-256
Authorization Requirements 2-256
Transaction Initiation and Termination 2-256
Isolation Levels of Transactions and Access Options of Statements 2-257
Use of a VALUES Clause for the Source Query Expression 2-257
Inserting From Host Variables 2-257
Requirements for Inserted Rows 2-258
Using Compatible Data Types 2-258
Audited and Nonaudited Tables 2-259
Considerations for self-referencing inserts 2-259
MXCI Examples of INSERT
2-261
C Examples of INSERT 2-266
COBOL Examples of INSERT 2-266
LOCK TABLE Statement
2-267
Considerations for LOCK TABLE
2-267
Authorization Requirements 2-267
Modifying Default Locking
2-267
Unlocking Locked Tables
2-268
Effect of AUTOCOMMIT Option
2-268
Partitions and Indexes
2-268
Examples of LOCK TABLE 2-268
MODIFY Utility
2-270
Reuse an Existing Partition of a Range Partitioned Table 2-270