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

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-25
Q
C examples of 2-302
COBOL examples of 2-303
MXCI examples of 2-301
naming statements 2-301
scope of 2-300
syntax diagram of 2-299
Prepared SQL, statements for 2-4
PRESERVE_MIN_SCALE default 10-52
Primary key
ALTER TABLE statement 2-24
description of 6-63
Primary key constraint 6-9
PRIMARY_KEY_CONSTRAINT_DROPPA
BLE_OPTION default 10-50
PRIVILEGED_USERS 10-25
PRIVILEGED_USERS TABLE 10-11
Privileges
ALL PRIVILEGES 2-241
DELETE 2-241
GRANT EXECUTE statement 2-247
GRANT statement use of 2-3, 2-240
INSERT 2-241
REFERENCES 2-241
required to execute utilities 5-2
REVOKE EXECUTE statement 2-323
REVOKE statement use of 2-317
SELECT 2-241
tables 2-241
UPDATE 2-241
Prompts, MXCI 1-2
Protection view 6-116
Q
Quantified comparison predicates
ALL, ANY, SOME 6-101
examples of 6-102
operand requirements 6-102
result of 6-102
syntax diagram of 6-101
QUARTER function
examples of 8-133
syntax diagram of 8-133
Query expression
DECLARE CURSOR use of 3-22
INSERT statement use of 2-254
SELECT statement use of 2-336
syntax diagram of 2-155, 2-252
Query specification
SELECT statement use of 2-340
simple table, form of 2-340
QUERYCACHE function
DISPLAY_QC command 8-134
examples of 8-136
result of 8-134
syntax diagram of 8-134
QUERYCACHEENTRIES function
DISPLAY_QC_ENTRIES
command 8-138
examples of 8-140
result of 8-139
syntax diagram of 8-138
Query, interruption of 1-5
QUERY_CACHE default 10-73
QUERY_CACHE_MAX_VICTIMS
default 10-73
QUERY_CACHE_REQUIRED_PREFIX_KE
YS default 10-74
QUERY_CACHE_STATEMENT_PINNING
default 10-74
Quick reference A-1
R
RADIANS function
examples of 8-143
syntax diagram of 8-143
Range partitioning
description of 6-83
MODIFY utility 2-271, 2-274
READ COMMITTED 1-8
READ UNCOMMITTED 1-8