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

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-12
D
MXCI examples of 2-152
Publish/Subscribe examples of 2-155
SET ON ROLLBACK clause 2-148
SET ROLLBACK clause 2-149
SKIP CONFLICT access 2-150
STREAM clause 2-148, 2-298
syntax diagram of 2-147
WHERE clause 2-149
DELETE statement (embedded)
C examples of 2-153
COBOL examples of 2-154
positioned form 2-147
searched form 2-147
Delimited identifiers 6-56
Derived column names
examples of 6-8
syntax of 6-7
DESCRIBE statement
C examples of 3-35
COBOL examples of 3-36
INPUT form 3-34
OUTPUT form 3-34
scope of 3-35
syntax diagram of 3-34
DETAIL_COST in EXPLAIN output
CPU_TIME 2-179
IDELTIME 2-179
IP_TIME 2-179
MSG_TIME 2-179
PROBES 2-179
DIFF1 function
equivalent definitions 9-54
examples of 9-55
syntax diagram of 9-54
DIFF2 function
equivalent definitions 9-57
examples of 9-58
syntax diagram of 9-57
DISPLAY STATISTICS command
examples of 4-24
syntax diagram of 4-23
DISPLAY USE OF command
examples of 4-12
syntax diagram 4-10
DISPLAY_QC command
examples of 4-20
purpose of 4-19
QUERYCACHE function and 4-19
syntax diagram of 4-19
DISPLAY_QC_ENTRIES command
examples of 4-22
purpose of 4-21
QUERYCACHE function and 4-21
syntax diagram of 4-21
DISTINCT clause
aggregate functions 2-261, 9-2
AVG function use of 9-14
COUNT function use of 9-38
MAX function use of 9-98
MIN function use of 9-99
STDDEV function use of 9-166
SUM function use of 9-171
VARIANCE function use of 9-202
DML statements
See Data Manipulation Language
(DML) statements
DOOM_USERTRANSACTION
default 10-77
DOUBLE PRECISION data type 6-37
DOWNGRADE utility 5-5
considerations for 5-5
example of 5-7
output options for 5-5
DP2_CACHE_4096_BLOCKS
default 10-67
DROP CATALOG statement
authorization and availability
requirements 2-156
examples of 2-156