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

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-9
D
DAY function
examples of 9-39
syntax diagram of 9-39
DAYNAME function
examples of 9-40
syntax diagram of 9-40
DAYOFMONTH function
examples of 9-41
syntax diagram of 9-41
DAYOFWEEK function
examples of 9-42
syntax diagram of 9-42
DAYOFYEAR function
examples of 9-43
syntax diagram of 9-43
DDL statements
See Data Definition Language (DDL)
statements
DDL_DEFAULT_LOCATIONS
default 10-51
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-32
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 (continued)
Publish/Subscribe examples of 3-5,
3-27
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-29
COBOL examples of 3-30
scope of 3-29
syntax diagram of 3-28
DECLARE NAMETYPE declaration
C examples of 3-31
COBOL examples of 3-31
scope of 3-31
syntax diagram of 3-31
DECLARE SCHEMA declaration
C examples of 3-32
COBOL examples of 3-32
scope of 3-32
syntax diagram of 3-32
DEFAULT clause
ALTER TABLE use of 2-12
CREATE TABLE use of 2-77, 7-2
default value 7-3
examples of 7-4
syntax diagram of 7-2
Default settings
ANSI compliance 1-32
ATTEMPT_ASYNCHRONOUS_ACCES
S 10-54
ATTEMPT_ESP_PARALLELISM 10-54
AUTOMATIC_RECOMPILATION 10-64
CACHE_HISTOGRAMS 10-41