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

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-11
D
Default settings (continued)
PREFERRED_PROBING_ORDER_FO
R_NESTED_JOIN 10-63
PRESERVE_MIN_SCALE 10-43
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 10-42
QUERY_CACHE 10-64
QUERY_CACHE_MAX_VICTIMS 10-6
4
QUERY_CACHE_REQUIRED_PREFIX
_KEYS 10-65
QUERY_CACHE_STATEMENT_PINNI
NG 10-65
READONLY_CURSOR 10-66
RECOMPILATION_WARNINGS 10-70
RECOMPILE_ON_PLANVERSION_ER
ROR 10-70
REF_CONSTRAINT_NO_ACTION_LIK
E_RESTRICT 10-66
REMOTE_ESP_ALLOCATION 10-63
SAVE_DROPPED_TABLE_DDL 10-72
SCHEMA 10-51
SCRATCH_DISKS 10-67
SCRATCH_DISKS_EXCLUDED 10-67
SCRATCH_DISKS_PREFERRED 10-6
7
SCRATCH_FREESPACE_THRESHOL
D_PERCENT 10-67
SIMILARITY_CHECK 10-70
SORT_MAX_HEAP_SIZE_MB 10-63
STREAM_TIMEOUT 10-72
TABLELOCK 10-48
TEMPORARY_TABLE_HASH_PARTITI
ONS 10-74
TIMEOUT 10-48
UDR_JAVA_OPTIONS 10-71
UPD_ABORT_ON_ERROR 10-69
UPD_ORDERED 10-63
UPD_SAVEPOINT_ON_ERROR 10-69
VARCHAR_PARAM_DEFAULT_SIZE 1
0-73
Default settings (continued)
ZIG_ZAG_TREES 10-63
DEFAULT value, using 2-172, 2-253
DEFAULTS table
See SYSTEM_DEFAULT table
DEFINE names
ADD DEFINE command 4-3
SQL/MP objects 6-14
DEFINEs
description of 6-35
in INVOKE in Windows NT 3-66
DEFINITION_SCHEMA_VERSION_vernum
schema
description of 10-4
tables 10-4
DEF_MAX_HISTORY_ROWS
default 10-68
DEGREES function
examples of 9-47
syntax diagram of 9-47
DELETE access privilege 2-161, 2-189
DELETE DEFINE command
examples of 4-8
syntax diagram of 4-8
DELETE statement
access options 2-117
file organization requirement 2-116
MXCI examples of 2-120
Publish/Subscribe examples of 2-123
SET ON ROLLBACK clause 2-116
SET ROLLBACK clause 2-117
SKIP CONFLICT access 2-118
STREAM clause 2-116, 2-251
syntax diagram of 2-115
WHERE clause 2-117
DELETE statement (embedded)
C examples of 2-121
COBOL examples of 2-122
positioned form 2-115
searched form 2-115