SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-12
D
DELETE statement (embedded)
C examples of 2-122
COBOL examples of 2-123
positioned form 2-116
searched form 2-116
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-148
IDELTIME 2-148
IP_TIME 2-148
MSG_TIME 2-148
PROBES 2-148
DIFF1 function
equivalent definitions 9-48
examples of 9-49
syntax diagram of 9-48
DIFF2 function
equivalent definitions 9-51
examples of 9-52
syntax diagram of 9-51
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
DISPLAY_QC command (continued)
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-217, 9-2
AVG function use of 9-14
COUNT function use of 9-35
MAX function use of 9-89
MIN function use of 9-90
STDDEV function use of 9-153
SUM function use of 9-158
VARIANCE function use of 9-180
DML statements
See Data Manipulation Language
(DML) statements
DOOM_USERTRANSACTION
default 10-74
DOUBLE PRECISION data type 6-37
DOWNGRADE utility 5-4
considerations for 5-4
example of 5-6
output options for 5-4
DP2_CACHE_4096_BLOCKS
default 10-64
DROP CATALOG statement
authorization and availability
requirements 2-125
examples of 2-125
syntax diagram of 2-125
DROP INDEX statement
authorization and availability
requirements 2-126
examples of 2-127
supporting a constraint 2-126
syntax diagram of 2-126
DROP PROCEDURE statement
examples of 2-128