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

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-12
D
Delimited identifiers 6-53
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-147
IDELTIME 2-147
IP_TIME 2-147
MSG_TIME 2-147
PROBES 2-147
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-23
syntax diagram of 4-22
DISPLAY USE OF command
examples of 4-11
syntax diagram 4-9
DISPLAY_QC command
examples of 4-19
purpose of 4-18
QUERYCACHE function and 4-18
syntax diagram of 4-18
DISPLAY_QC_ENTRIES command
examples of 4-21
purpose of 4-20
QUERYCACHE function and 4-20
DISPLAY_QC_ENTRIES
command (continued)
syntax diagram of 4-20
DISTINCT clause
aggregate functions 2-216, 9-2
AVG function use of 9-14
COUNT function use of 9-35
MAX function use of 9-85
MIN function use of 9-86
STDDEV function use of 9-146
SUM function use of 9-151
VARIANCE function use of 9-170
DML statements
See Data Manipulation Language
(DML) statements
DOOM_USERTRANSACTION
default 10-69
DOUBLE PRECISION data type 6-34
DP2_CACHE_4096_BLOCKS
default 10-58
DROP CATALOG statement
authorization and availability
requirements 2-124
examples of 2-124
syntax diagram of 2-124
DROP INDEX statement
authorization and availability
requirements 2-125
examples of 2-126
supporting a constraint 2-125
syntax diagram of 2-125
DROP PROCEDURE statement
examples of 2-127
syntax diagram of 2-126
DROP SCHEMA statement
authorization and availability
requirements 2-127
examples of 2-129
limits C-1
syntax diagram of 2-127