SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-11
D
Default settings (continued)
POS_LOCATIONS 10-62
POS_NUM_OF_PARTNS 10-62
POS_RAISE_ERROR 10-62
PREFERRED_PROBING_ORDER_FO
R_NESTED_JOIN 10-68
PRESERVE_MIN_SCALE 10-49
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 10-47
QUERY_CACHE 10-70
QUERY_CACHE_MAX_VICTIMS 10-7
0
QUERY_CACHE_REQUIRED_PREFIX
_KEYS 10-70
QUERY_CACHE_STATEMENT_PINNI
NG 10-71
READONLY_CURSOR 10-72
RECOMPILATION_WARNINGS 10-75
RECOMPILE_ON_PLANVERSION_ER
ROR 10-75
REF_CONSTRAINT_NO_ACTION_LIK
E_RESTRICT 10-71
REMOTE_ESP_ALLOCATION 10-69
SAVE_DROPPED_TABLE_DDL 10-78
SCHEMA 10-58
SCRATCH_DISKS 10-72
SCRATCH_DISKS_EXCLUDED 10-72
SCRATCH_DISKS_PREFERRED 10-7
2
SCRATCH_FREESPACE_THRESHOL
D_PERCENT 10-72
SIMILARITY_CHECK 10-75
SORT_MAX_HEAP_SIZE_MB 10-69
STREAM_TIMEOUT 10-77
TABLELOCK 10-54
TEMPORARY_TABLE_HASH_PARTITI
ONS 10-79
TIMEOUT 10-54
UDR_JAVA_OPTIONS 10-76
UPD_ABORT_ON_ERROR 10-74
UPD_ORDERED 10-69
Default settings (continued)
UPD_SAVEPOINT_ON_ERROR 10-74
VARCHAR_PARAM_DEFAULT_SIZE 1
0-79
ZIG_ZAG_TREES 10-69
DEFAULT value, using 2-173, 2-256
DEFAULTS table
See SYSTEM_DEFAULT table
DEFAULT_BLOCKSIZE default 10-77
DEFINE names
ADD DEFINE command 4-4
SQL/MP objects 6-14
DEFINEs
description of 6-38
in INVOKE in Windows NT 3-66
DEFINITION_SCHEMA_VERSION_vernum
schema
description of 10-3
tables 10-4
DEF_MAX_HISTORY_ROWS
default 10-73
DEGREES function
examples of 9-47
syntax diagram of 9-47
DELETE access privilege 2-162, 2-190
DELETE DEFINE command
examples of 4-9
syntax diagram of 4-9
DELETE statement
access options 2-118
file organization requirement 2-117
MXCI examples of 2-121
Publish/Subscribe examples of 2-124
SET ON ROLLBACK clause 2-117
SET ROLLBACK clause 2-118
SKIP CONFLICT access 2-119
STREAM clause 2-117, 2-254
syntax diagram of 2-116
WHERE clause 2-118