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

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-25
Q
LIKE 6-97
NULL 6-99
quantified comparison 6-101
PREFERRED_PROBING_ORDER_FOR_N
ESTED_JOIN default 10-74
PREPARE statement
availability 2-237
C examples of 2-239
COBOL examples of 2-240
MXCI examples of 2-238
naming statements 2-238
scope of 2-237
syntax diagram of 2-236
Prepared SQL, statements for 2-4
PRESERVE_MIN_SCALE default 10-53
Primary key
ALTER TABLE statement 2-17
description of 6-63
Primary key constraint 6-9
PRIMARY_KEY_CONSTRAINT_DROPPA
BLE_OPTION default 10-51
PRIVILEGED_USERS 10-26
PRIVILEGED_USERS TABLE 10-12
Privileges
ALL PRIVILEGES 2-206
DELETE 2-206
GRANT EXECUTE statement 2-211
GRANT statement use of 2-3, 2-205
INSERT 2-206
REFERENCES 2-206
required to execute utilities 5-3
REVOKE EXECUTE statement 2-248
REVOKE statement use of 2-243
SELECT 2-206
tables 2-206
UPDATE 2-206
Prompts, MXCI 1-2
Protection view 6-113
PURGEDATA utility 5-130
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-133
syntax diagram of 9-133
Query expression
DECLARE CURSOR use of 3-22
INSERT statement use of 2-219
SELECT statement use of 2-261
syntax diagram of 2-143, 2-217
Query specification
SELECT statement use of 2-265
simple table, form of 2-265
QUERYCACHE function
DISPLAY_QC command 9-134
examples of 9-136
result of 9-134
syntax diagram of 9-134
QUERYCACHEENTRIES function
DISPLAY_QC_ENTRIES
command 9-138
examples of 9-140
result of 9-139
syntax diagram of 9-138
Query, interruption of 1-6
QUERY_CACHE default 10-75
QUERY_CACHE_MAX_VICTIMS
default 10-75
QUERY_CACHE_REQUIRED_PREFIX_KE
YS default 10-76
QUERY_CACHE_STATEMENT_PINNING
default 10-76
Quick reference A-1