SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-25
Q
PREFERRED_PROBING_ORDER_FOR_N
ESTED_JOIN default 10-71
PREPARE statement
availability 2-225
C examples of 2-227
COBOL examples of 2-228
MXCI examples of 2-226
naming statements 2-226
scope of 2-225
syntax diagram of 2-224
Prepared SQL, statements for 2-4
PRESERVE_MIN_SCALE default 10-52
Primary key
ALTER TABLE statement 2-17
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-198
DELETE 2-198
GRANT EXECUTE statement 2-203
GRANT statement use of 2-3, 2-198
INSERT 2-198
REFERENCES 2-198
required to execute utilities 5-3
REVOKE EXECUTE statement 2-236
REVOKE statement use of 2-231
SELECT 2-198
tables 2-198
UPDATE 2-198
Prompts, MXCI 1-2
Protection view 6-113
PURGEDATA utility 5-120
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-128
syntax diagram of 9-128
Query expression
DECLARE CURSOR use of 3-22
INSERT statement use of 2-211
SELECT statement use of 2-248
syntax diagram of 2-142, 2-209
Query specification
SELECT statement use of 2-252
simple table, form of 2-252
QUERYCACHE function
DISPLAY_QC command 9-129
examples of 9-131
result of 9-129
syntax diagram of 9-129
QUERYCACHEENTRIES function
DISPLAY_QC_ENTRIES
command 9-133
examples of 9-135
result of 9-134
syntax diagram of 9-133
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-73
QUERY_CACHE_STATEMENT_PINNING
default 10-74
Quick reference A-1
R
RADIANS function
examples of 9-138
syntax diagram of 9-138