SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-12
D
file organization requirement 2-152
MXCI examples of 2-157
Publish/Subscribe examples of 2-161
SET ON ROLLBACK clause 2-152
SET ROLLBACK clause 2-152
SKIP CONFLICT access 2-153
STREAM clause 2-152, 2-311
syntax diagram of 2-150
WHERE clause 2-153
DELETE statement (embedded)
C examples of 2-160
COBOL examples of 2-160
positioned form 2-150
searched form 2-150
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-186
IDELTIME 2-186
IP_TIME 2-186
MSG_TIME 2-186
PROBES 2-186
DIFF1 function
equivalent definitions 9-59
examples of 9-60
syntax diagram of 9-59
DIFF2 function
equivalent definitions 9-62
examples of 9-63
syntax diagram of 9-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-274, 9-2
AVG function use of 9-14
COUNT function use of 9-38
MAX function use of 9-103
MIN function use of 9-104
STDDEV function use of 9-171
SUM function use of 9-176
VARIANCE function use of 9-207
DML statements
See Data Manipulation Language
(DML) statements
DOOM_USERTRANSACTION
default 10-80
DOUBLE PRECISION data type 6-37
DOWNGRADE utility 5-9
considerations for 5-10
example of 5-12
output options for 5-10
DP2_CACHE_4096_BLOCKS
default 10-70
DROP CATALOG statement
authorization and availability
requirements 2-163