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

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-9
D
DAY function
examples of 9-42
syntax diagram of 9-42
DAYNAME function
examples of 9-43
syntax diagram of 9-43
DAYOFMONTH function
examples of 9-44
syntax diagram of 9-44
DAYOFWEEK function
examples of 9-45
syntax diagram of 9-45
DAYOFYEAR function
examples of 9-46
syntax diagram of 9-46
DDL statements
See Data Definition Language (DDL)
statements
DDL_DEFAULT_LOCATIONS
default 10-54
DDL_LOCKS metadata table 10-18
DEALLOCATE DESCRIPTOR statement
examples of 3-17
syntax diagram of 3-16
DEALLOCATE file attribute 8-2
DEALLOCATE PREPARE statement
C examples of 3-19
COBOL examples of 3-20
syntax diagram of 3-18
DECIMAL data type 6-33
DECLARE CATALOG declaration
C examples of 3-21
COBOL examples of 3-21
scope of 3-21
syntax diagram of 3-21
DECLARE CURSOR declaration
C examples of 3-25
COBOL examples of 3-26
default for updatability 3-24
DECLARE CURSOR declaration
DECLARE CURSOR
declaration (continued)
Publish/Subscribe examples of 3-5,
3-28
query expression within 3-23
specifying read-only cursor 3-23
specifying updatable cursor 3-23
static and dynamic forms 3-22
syntax diagram of 3-22
WITH HOLD clause 3-23
WITH HOLD limitations 3-25
DECLARE MPLOC declaration
C examples of 3-30
COBOL examples of 3-31
scope of 3-30
syntax diagram of 3-29
DECLARE NAMETYPE declaration
C examples of 3-32
COBOL examples of 3-32
scope of 3-32
syntax diagram of 3-32
DECLARE SCHEMA declaration
C examples of 3-33
COBOL examples of 3-33
scope of 3-33
syntax diagram of 3-33
DEFAULT clause
ALTER TABLE use of 2-12
CREATE TABLE use of 2-82, 7-2
default value 7-3
examples of 7-4
syntax diagram of 7-2
Default settings
ALLOW_DP2_ROW_SAMPLING 10-5
7
ANSI compliance 1-32
ATTEMPT_ASYNCHRONOUS_ACCES
S 10-57
ATTEMPT_ESP_PARALLELISM 10-57
AUTOMATIC_RECOMPILATION 10-69