SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-11
D
DEFINITION_SCHEMA_VERSION_vernum
schema (continued)
tables 10-4
DEF_MAX_HISTORY_ROWS
default 10-61
DEGREES function
examples of 9-48
syntax diagram of 9-48
DELETE access privilege 2-141, 2-170
DELETE DEFINE command
examples of 4-8
syntax diagram of 4-8
DELETE statement
access options 2-112
file organization requirement 2-111
MXCI examples of 2-115
Publish/Subscribe examples of 2-118
SET ON ROLLBACK clause 2-112
SET ROLLBACK clause 2-112
SKIP CONFLICT access 2-113
STREAM clause 2-111, 2-232
syntax diagram of 2-110
WHERE clause 2-112
DELETE statement (embedded)
C examples of 2-116
COBOL examples of 2-117
positioned form 2-110
searched form 2-110
Delimited identifiers 6-54
Derived column names
examples of 6-7
syntax of 6-6
DESCRIBE statement
C examples of 3-34
COBOL examples of 3-35
INPUT form 3-33
OUTPUT form 3-33
scope of 3-34
syntax diagram of 3-33
DIFF1 function
equivalent definitions 9-49
examples of 9-50
syntax diagram of 9-49
DIFF2 function
equivalent definitions 9-52
examples of 9-53
syntax diagram of 9-52
DISPLAY STATISTICS command
examples of 4-23
syntax diagram of 4-22
DISPLAY USE OF command
examples of 4-10
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-197, 9-2
AVG function use of 9-16
COUNT function use of 9-35
MAX function use of 9-81
MIN function use of 9-82
STDDEV function use of 9-147
SUM function use of 9-152
VARIANCE function use of 9-173