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

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-9
D
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-34
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
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
DECLARE SCHEMA
declaration (continued)
scope of 3-32
syntax diagram of 3-32
DEFAULT clause
ALTER TABLE use of 2-13
CREATE TABLE use of 2-78, 7-2
default value 7-3
examples of 7-4
syntax diagram of 7-2
Default settings
ANSI compliance 1-31
ATTEMPT_ASYNCHRONOUS_ACCES
S 10-53
ATTEMPT_ESP_PARALLELISM 10-53
CACHE_HISTOGRAMS 10-40
CATALOG 10-47
CROSS_PRODUCT_CONTROL 10-53
DATA_FLOW_OPTIMIZATION 10-53
DDL_DEFAULT_LOCATIONS 10-50
DEF_MAX_HISTORY_ROWS 10-61
DP2_CACHE_4096_BLOCKS 10-54
FFDC_DIALOUTS_FOR_MXCMP 10-5
4
FLOATTYPE 10-39
GENERATE_EXPLAIN 10-54
GEN_EIDR_BUFFER_SIZE 10-54
GEN_MAX_NUM_PART_DISK_ENTRI
ES 10-51
GEN_PA_BUFFER_SIZE 10-55
HIST_NO_STATS_REFRESH_INTERV
AL 10-42
HIST_NO_STATS_ROWCOUNT 10-42
HIST_NO_STATS_UEC 10-42
HIST_PREFETCH 10-42
HIST_ROWCOUNT_REQUIRING_STA
TS 10-43
HIST_SAME_TABLE_PRED_REDUCTI
ON 10-43
HIST_SCRATCH_VOL 10-43