SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-11
D
NOT_NULL_CONSTRAINT_DROPPAB
LE_OPTION 10-50
NUMBER_OF_USERS 10-70
OLT_QUERY_OPT 10-70
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-71
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-73
QUERY_CACHE_STATEMENT_PINNI
NG 10-74
READONLY_CURSOR 10-75
RECOMPILATION_WARNINGS 10-78
RECOMPILE_ON_PLANVERSION_ER
ROR 10-78
REF_CONSTRAINT_NO_ACTION_LIK
E_RESTRICT 10-74
REMOTE_ESP_ALLOCATION 10-72
SAVE_DROPPED_TABLE_DDL 10-81
SCHEMA 10-61
SCRATCH_DISKS 10-75
SCRATCH_DISKS_EXCLUDED 10-75
SCRATCH_DISKS_PREFERRED 10-7
5
SCRATCH_FREESPACE_THRESHOL
D_PERCENT 10-75
SIMILARITY_CHECK 10-78
SORT_MAX_HEAP_SIZE_MB 10-72
STREAM_TIMEOUT 10-80
TABLELOCK 10-57
TEMPORARY_TABLE_HASH_PARTITI
ONS 10-82
TIMEOUT 10-57
UDR_JAVA_OPTIONS 10-79
UPD_ABORT_ON_ERROR 10-77
UPD_ORDERED 10-72
UPD_SAVEPOINT_ON_ERROR 10-77
VARCHAR_PARAM_DEFAULT_SIZE 1
0-82
ZIG_ZAG_TREES 10-72
DEFAULT value, using 2-213, 2-300
DEFAULTS table
See SYSTEM_DEFAULT table
DEFAULT_BLOCKSIZE default 10-80
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-76
DEGREES function
examples of 9-52
syntax diagram of 9-52
DELETE access privilege 2-198, 2-231
DELETE DEFINE command
examples of 4-9
syntax diagram of 4-9
DELETE statement
access options 2-149
file organization requirement 2-148