SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-12
D
DESCRIBE statement (continued)
OUTPUT form 3-33
scope of 3-34
syntax diagram of 3-33
DIFF1 function
equivalent definitions 9-45
examples of 9-46
syntax diagram of 9-45
DIFF2 function
equivalent definitions 9-48
examples of 9-49
syntax diagram of 9-48
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_EXPLAIN command
examples of 4-14
EXPLAIN function and 4-13
purpose of 4-14
syntax diagram of 4-13
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
syntax diagram of 4-20
DISTINCT clause
aggregate functions 2-193, 9-2
AVG function use of 9-14
COUNT function use of 9-32
MAX function use of 9-81
MIN function use of 9-82
STDDEV function use of 9-142
DISTINCT clause (continued)
SUM function use of 9-147
VARIANCE function use of 9-166
DML statements
See Data Manipulation Language
(DML) statements
DOOM_USERTRANSACTION
default 10-64
DOUBLE PRECISION data type 6-33
DP2_CACHE_4096_BLOCKS
default 10-55
DROP CATALOG statement
authorization and availability
requirements 2-118
examples of 2-118
syntax diagram of 2-118
DROP INDEX statement
authorization and availability
requirements 2-119
examples of 2-120
supporting a constraint 2-119
syntax diagram of 2-119
DROP PROCEDURE statement
examples of 2-121
syntax diagram of 2-120
DROP SCHEMA statement
authorization and availability
requirements 2-121
examples of 2-123
limits C-1
syntax diagram of 2-121
DROP SQL statement
authorization and availability
requirements 2-124
examples of 2-124
syntax diagram of 2-124
DROP SQLMP ALIAS statement
examples of 2-126
syntax diagram of 2-125
usage restrictions 2-125