SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-24
Q
Precision, description of 6-49
Predicates
summary of 6-81
BETWEEN 6-82
comparison 6-84
description of 6-81
EXISTS 6-88
IN 6-90
LIKE 6-93
NULL 6-95
quantified comparison 6-97
PREFERRED_PROBING_ORDER_FOR_N
ESTED_JOIN default 10-58
PREPARE statement
availability 2-160
C examples of 2-162
COBOL examples of 2-163
MXCI examples of 2-161
naming statements 2-161
scope of 2-160
syntax diagram of 2-159
Prepared SQL, statements for 2-3
PRESERVE_MIN_SCALE default 10-41
Primary key
ALTER TABLE statement 2-14
description of 6-59
Primary key constraint 6-8
PRIMARY_KEY_CONSTRAINT_DROPPA
BLE_OPTION default 10-40
Privileges
ALL PRIVILEGES 2-138
DELETE 2-138
GRANT EXECUTE statement 2-141
GRANT statement use of 2-138
INSERT 2-138
REFERENCES 2-138
required to execute utilities 5-2
REVOKE EXECUTE statement 2-169
REVOKE statement use of 2-166
SELECT 2-138
Privileges (continued)
tables 2-138
UPDATE 2-138
Prompts, MXCI 1-2
Protection view 6-109
PURGEDATA utility 5-76
Q
Quantified comparison predicates
ALL, ANY, SOME 6-97
examples of 6-98
operand requirements 6-98
result of 6-98
syntax diagram of 6-97
QUARTER function
examples of 9-107
syntax diagram of 9-107
Query expression
DECLARE CURSOR use of 3-22
INSERT statement use of 2-147
SELECT statement use of 2-180
syntax diagram of 2-104, 2-145
Query specification
SELECT statement use of 2-184
simple table, form of 2-184
QUERYCACHE function
DISPLAY_QC command 9-108
examples of 9-110
result of 9-108
syntax diagram of 9-108
QUERYCACHEENTRIES function
DISPLAY_QC_ENTRIES
command 9-112
examples of 9-114
result of 9-113
syntax diagram of 9-112
Query, interruption of 1-5
QUERY_CACHE default 10-59
QUERY_CACHE_MAX_VICTIMS
default 10-59