SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-24
Q
POSITION function
examples of 9-110
result of 9-109
syntax diagram of 9-109
POS_LOCATIONS default 10-55
POS_NUM_OF_PARTNS default 10-55
POS_RAISE_ERROR default 10-56
POWER function
examples of 9-110
syntax diagram of 9-110
Precision, description of 6-50
Predicates
summary of 6-82
BETWEEN 6-83
comparison 6-85
description of 6-82
EXISTS 6-89
IN 6-91
LIKE 6-94
NULL 6-96
quantified comparison 6-98
PREFERRED_PROBING_ORDER_FOR_N
ESTED_JOIN default 10-63
PREPARE statement
availability 2-183
C examples of 2-185
COBOL examples of 2-186
MXCI examples of 2-184
naming statements 2-184
scope of 2-183
syntax diagram of 2-182
Prepared SQL, statements for 2-3
PRESERVE_MIN_SCALE default 10-43
Primary key
ALTER TABLE statement 2-14
description of 6-60
Primary key constraint 6-9
PRIMARY_KEY_CONSTRAINT_DROPPA
BLE_OPTION default 10-42
Privileges
ALL PRIVILEGES 2-161
DELETE 2-161
GRANT EXECUTE statement 2-164
GRANT statement use of 2-161
INSERT 2-161
REFERENCES 2-161
required to execute utilities 5-2
REVOKE EXECUTE statement 2-192
REVOKE statement use of 2-189
SELECT 2-161
tables 2-161
UPDATE 2-161
Prompts, MXCI 1-2
Protection view 6-110
PURGEDATA utility 5-111
Q
Quantified comparison predicates
ALL, ANY, SOME 6-98
examples of 6-99
operand requirements 6-99
result of 6-99
syntax diagram of 6-98
QUARTER function
examples of 9-111
syntax diagram of 9-111
Query expression
DECLARE CURSOR use of 3-22
INSERT statement use of 2-170
SELECT statement use of 2-203
syntax diagram of 2-110, 2-168
Query specification
SELECT statement use of 2-207
simple table, form of 2-207
QUERYCACHE function
DISPLAY_QC command 9-112
examples of 9-114
result of 9-112