SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-23
Q
Predicates
summary of 6-84
BETWEEN 6-85
comparison 6-87
description of 6-84
EXISTS 6-91
IN 6-93
LIKE 6-96
NULL 6-98
quantified comparison 6-99
PREFERRED_PROBING_ORDER_FOR_N
ESTED_JOIN default 10-57
PREPARE statement
availability 2-164
C examples of 2-166
COBOL examples of 2-167
MXCI examples of 2-165
naming statements 2-165
scope of 2-164
syntax diagram of 2-163
Prepared SQL, statements for 2-3
PRESERVE_MIN_SCALE default 10-40
Primary key
ALTER TABLE statement 2-15
description of 6-61
Primary key constraint 6-8
PRIMARY_KEY_CONSTRAINT_DROPPA
BLE_OPTION default 10-39
Privileges
ALL PRIVILEGES 2-141
DELETE 2-141
GRANT EXECUTE statement 2-145
GRANT statement use of 2-141
INSERT 2-141
REFERENCES 2-141
required to execute utilities 5-2
REVOKE EXECUTE statement 2-173
REVOKE statement use of 2-170
SELECT 2-141
tables 2-141
Privileges (continued)
UPDATE 2-141
Prompts, MXCI 1-2
Protection view 6-112
PURGEDATA utility 5-72
Q
Quantified comparison predicates
ALL, ANY, SOME 6-100
examples of 6-101
operand requirements 6-101
result of 6-101
syntax diagram of 6-100
QUARTER function
examples of 9-108
syntax diagram of 9-108
Query expression
DECLARE CURSOR use of 3-22
INSERT statement use of 2-151
SELECT statement use of 2-184
syntax diagram of 2-105, 2-149
Query specification
SELECT statement use of 2-188
simple table, form of 2-188
QUERYCACHE function
DISPLAY_QC command 9-109
examples of 9-111
result of 9-109
syntax diagram of 9-109
QUERYCACHEENTRIES function
DISPLAY_QC_ENTRIES
command 9-113
examples of 9-116
result of 9-114
syntax diagram of 9-113
Query, interruption of 1-4
QUERY_CACHE default 10-58
QUERY_CACHE_MAX_VICTIMS
default 10-58