SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-11
D
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 10-50
NUMBER_OF_USERS 10-71
OLT_QUERY_OPT 10-71
OPTIMIZATION_LEVEL 10-71
OPTS_PUSH_DOWN_DAM 10-71
PARALLEL_NUM_ESPS 10-71
PM_OFFLINE_TRANSACTION_GRAN
ULARITY 10-64
PM_ONLINE_TRANSACTION_GRANU
LARITY 10-64
POS_LOCATIONS 10-65
POS_NUM_OF_PARTNS 10-65
POS_RAISE_ERROR 10-65
PREFERRED_PROBING_ORDER_FO
R_NESTED_JOIN 10-72
PRESERVE_MIN_SCALE 10-52
PRIMARY_KEY_CONSTRAINT_DROP
PABLE_OPTION 10-50
QUERY_CACHE 10-73
QUERY_CACHE_MAX_VICTIMS 10-7
3
QUERY_CACHE_REQUIRED_PREFIX
_KEYS 10-74
QUERY_CACHE_STATEMENT_PINNI
NG 10-74
READONLY_CURSOR 10-75
RECOMPILATION_WARNINGS 10-79
RECOMPILE_ON_PLANVERSION_ER
ROR 10-79
REF_CONSTRAINT_NO_ACTION_LIK
E_RESTRICT 10-75
REMOTE_ESP_ALLOCATION 10-72
SAVE_DROPPED_TABLE_DDL 10-82
SCHEMA 10-61
SCRATCH_DISKS 10-76
SCRATCH_DISKS_EXCLUDED 10-76
SCRATCH_DISKS_PREFERRED 10-7
6
SCRATCH_FREESPACE_THRESHOL
D_PERCENT 10-76
SIMILARITY_CHECK 10-79
SORT_MAX_HEAP_SIZE_MB 10-72
STREAM_TIMEOUT 10-81
TABLELOCK 10-57
TEMPORARY_TABLE_HASH_PARTITI
ONS 10-83
TIMEOUT 10-57
UDR_JAVA_OPTIONS 10-80
UPD_ABORT_ON_ERROR 10-78
UPD_ORDERED 10-72
UPD_SAVEPOINT_ON_ERROR 10-78
VARCHAR_PARAM_DEFAULT_SIZE 1
0-83
ZIG_ZAG_TREES 10-72
DEFAULT value, using 2-256, 2-388
DEFAULTS table
See SYSTEM_DEFAULT table
DEFAULT_BLOCKSIZE default 10-81
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-77
DEGREES function
examples of 8-57
syntax diagram of 8-57
DELETE access privilege 2-241, 2-317
DELETE DEFINE command
examples of 4-9
syntax diagram of 4-9
DELETE statement
access options 2-165
file organization requirement 2-164