SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-25
Q
PREPARE statement (continued)
MXCI examples of 2-185
naming statements 2-185
scope of 2-184
syntax diagram of 2-183
Prepared SQL, statements for 2-3
PRESERVE_MIN_SCALE default 10-49
Primary key
ALTER TABLE statement 2-14
description of 6-63
Primary key constraint 6-9
PRIMARY_KEY_CONSTRAINT_DROPPA
BLE_OPTION default 10-47
Privileges
ALL PRIVILEGES 2-162
DELETE 2-162
GRANT EXECUTE statement 2-165
GRANT statement use of 2-162
INSERT 2-162
REFERENCES 2-162
required to execute utilities 5-2
REVOKE EXECUTE statement 2-193
REVOKE statement use of 2-190
SELECT 2-162
tables 2-162
UPDATE 2-162
Prompts, MXCI 1-2
Protection view 6-113
PURGEDATA utility 5-115
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 9-115
syntax diagram of 9-115
Query expression
DECLARE CURSOR use of 3-22
INSERT statement use of 2-171
SELECT statement use of 2-204
syntax diagram of 2-111, 2-169
Query specification
SELECT statement use of 2-208
simple table, form of 2-208
QUERYCACHE function
DISPLAY_QC command 9-116
examples of 9-118
result of 9-116
syntax diagram of 9-116
QUERYCACHEENTRIES function
DISPLAY_QC_ENTRIES
command 9-120
examples of 9-122
result of 9-121
syntax diagram of 9-120
Query, interruption of 1-5
QUERY_CACHE default 10-70
QUERY_CACHE_MAX_VICTIMS
default 10-70
QUERY_CACHE_REQUIRED_PREFIX_KE
YS default 10-70
QUERY_CACHE_STATEMENT_PINNING
default 10-71
Quick reference A-1
R
RADIANS function
examples of 9-125
syntax diagram of 9-125
Range partitioning
description of 6-83
MODIFY utility 5-72, 5-74
READ COMMITTED 1-7
READ UNCOMMITTED 1-7
READONLY_CURSOR default 10-72
REAL data type 6-37