SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-12
D
MXCI examples of 2-169
Publish/Subscribe examples of 2-173
SET ON ROLLBACK clause 2-164
SET ROLLBACK clause 2-164
SKIP CONFLICT access 2-165
STREAM clause 2-164, 2-386
syntax diagram of 2-162
WHERE clause 2-165
DELETE statement (embedded)
C examples of 2-172
COBOL examples of 2-172
positioned form 2-162
searched form 2-162
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-211
IDELTIME 2-211
IP_TIME 2-211
MSG_TIME 2-211
PROBES 2-211
DIFF1 function
equivalent definitions 8-59
examples of 8-60
syntax diagram of 8-59
DIFF2 function
equivalent definitions 8-62
examples of 8-63
syntax diagram of 8-62
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-349, 8-2
AVG function use of 8-14
COUNT function use of 8-38
MAX function use of 8-103
MIN function use of 8-104
STDDEV function use of 8-171
SUM function use of 8-176
VARIANCE function use of 8-207
DML statements
See Data Manipulation Language
(DML) statements
DOOM_USERTRANSACTION
default 10-78
DOUBLE PRECISION data type 6-37
DOWNGRADE utility 2-175
considerations for 2-176
example of 2-178
output options for 2-176
DP2_CACHE_4096_BLOCKS
default 10-68
DROP CATALOG statement
authorization and availability
requirements 2-180
examples of 2-180