SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-11
D
NAMETYPE 10-62
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 10-51
NUMBER_OF_USERS 10-73
OLT_QUERY_OPT 10-73
OPTIMIZATION_LEVEL 10-73
OPTS_PUSH_DOWN_DAM 10-73
PARALLEL_NUM_ESPS 10-73
PM_OFFLINE_TRANSACTION_GRAN
ULARITY 10-66
PM_ONLINE_TRANSACTION_GRANU
LARITY 10-66
POS_LOCATIONS 10-66
POS_NUM_OF_PARTNS 10-66
POS_RAISE_ERROR 10-67
PREFERRED_PROBING_ORDER_FO
R_NESTED_JOIN 10-74
PRESERVE_MIN_SCALE 10-53
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 10-51
QUERY_CACHE 10-75
QUERY_CACHE_MAX_VICTIMS 10-7
5
QUERY_CACHE_REQUIRED_PREFIX
_KEYS 10-76
QUERY_CACHE_STATEMENT_PINNI
NG 10-76
READONLY_CURSOR 10-77
RECOMPILATION_WARNINGS 10-81
RECOMPILE_ON_PLANVERSION_ER
ROR 10-81
REF_CONSTRAINT_NO_ACTION_LIK
E_RESTRICT 10-77
REMOTE_ESP_ALLOCATION 10-74
SAVE_DROPPED_TABLE_DDL 10-84
SCHEMA 10-62
SCRATCH_DISKS 10-78
SCRATCH_DISKS_EXCLUDED 10-78
SCRATCH_DISKS_PREFERRED 10-7
8
SCRATCH_FREESPACE_THRESHOL
D_PERCENT 10-78
SIMILARITY_CHECK 10-81
SORT_MAX_HEAP_SIZE_MB 10-74
STREAM_TIMEOUT 10-83
TABLELOCK 10-58
TEMPORARY_TABLE_HASH_PARTITI
ONS 10-85
TIMEOUT 10-58
UDR_JAVA_OPTIONS 10-82
UPD_ABORT_ON_ERROR 10-80
UPD_ORDERED 10-74
UPD_SAVEPOINT_ON_ERROR 10-80
VARCHAR_PARAM_DEFAULT_SIZE 1
0-85
ZIG_ZAG_TREES 10-74
DEFAULT value, using 2-221, 2-313
DEFAULTS table
See SYSTEM_DEFAULT table
DEFAULT_BLOCKSIZE default 10-83
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-79
DEGREES function
examples of 9-57
syntax diagram of 9-57
DELETE access privilege 2-206, 2-243
DELETE DEFINE command
examples of 4-9
syntax diagram of 4-9
DELETE statement
access options 2-153