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

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-11
D
Default settings (continued)
QUERY_CACHE 10-59
QUERY_CACHE_MAX_VICTIMS 10-5
9
QUERY_CACHE_REQUIRED_PREFIX
_KEYS 10-60
QUERY_CACHE_STATEMENT_PINNI
NG 10-60
READONLY_CURSOR 10-61
RECOMPILATION_WARNINGS 10-65
REF_CONSTRAINT_NO_ACTION_LIK
E_RESTRICT 10-61
REMOTE_ESP_ALLOCATION 10-58
SAVE_DROPPED_TABLE_DDL 10-67
SCHEMA 10-49
SCRATCH_DISKS 10-62
SCRATCH_DISKS_EXCLUDED 10-62
SCRATCH_DISKS_PREFERRED 10-6
2
SCRATCH_FREESPACE_THRESHOL
D_PERCENT 10-62
SIMILARITY_CHECK 10-65
SORT_MAX_HEAP_SIZE_MB 10-59
STREAM_TIMEOUT 10-67
TABLELOCK 10-46
TEMPORARY_TABLE_HASH_PARTITI
ONS 10-69
TIMEOUT 10-46
UDR_JAVA_OPTIONS 10-66
UPD_ABORT_ON_ERROR 10-64
UPD_ORDERED 10-59
UPD_SAVEPOINT_ON_ERROR 10-64
VARCHAR_PARAM_DEFAULT_SIZE 1
0-68
ZIG_ZAG_TREES 10-59
DEFAULT value, using 2-149, 2-229
DEFAULTS table
See SYSTEM_DEFAULT table
DEFINE names
ADD DEFINE command 4-3
SQL/MP objects 6-13
DEFINEs
description of 6-34
in INVOKE in Windows NT 3-65
DEFINITION_SCHEMA_VERSION_vernum
schema
description of 10-4
tables 10-4
DEF_MAX_HISTORY_ROWS
default 10-63
DEGREES function
examples of 9-44
syntax diagram of 9-44
DELETE access privilege 2-138, 2-166
DELETE DEFINE command
examples of 4-8
syntax diagram of 4-8
DELETE statement
access options 2-111
file organization requirement 2-110
MXCI examples of 2-114
Publish/Subscribe examples of 2-116
SET ON ROLLBACK clause 2-110
SET ROLLBACK clause 2-111
SKIP CONFLICT access 2-112
STREAM clause 2-110, 2-227
syntax diagram of 2-109
WHERE clause 2-111
DELETE statement (embedded)
C examples of 2-115
COBOL examples of 2-116
positioned form 2-109
searched form 2-109
Delimited identifiers 6-52
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