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

What’s New in This Manual
HP NonStop SQL/MX Reference Manual—544517-008
xxxiv
Changes to the H06.18/J06.07 Manual
°
TRIM on page 9-158
•
Updated DDL_LOCKS Table on page 10-18.
•
Updated the value range of the following attributes:
°
CACHE_HISTOGRAMS_ REFRESH_INTERVAL
°
HIST_NO_STATS_REFRESH_ INTERVAL
°
HIST_NO_STATS_ROWCOUNT
°
HIST_NO_STATS_UEC
°
HIST_ROWCOUNT_ REQUIRING_STATS
°
TIMEOUT
°
GEN_MAX_NUM_PART_ DISK_ENTRIES
°
GEN_MAX_NUM_PART_ NODE_ENTRIES
°
MSCF_ET_REMOTE_MSG_ TRANSFER
°
PARALLEL_NUM_ESPS
°
STREAM_TIMEOUT
•
Updated the value of the following attributes:
°
POS_RAISE_ERROR
°
OPTS_PUSH_DOWN_DAM
•
Updated the description of SKIP_UNAVAILABLE_PARTITION on page 10-49.
•
Added the attribute CHECK_CONSTRAINT_PRUNING and its description on page
10-58.
•
Added the attribute MULTIUNION and its description on page 10-61.
•
Added the attribute UNION_TRANSITIVE_PREDICATES and its description on
page 10-63.
Changes to the H06.18/J06.07 Manual
•
Updated mxexportddl Utility on page 5-88.
•
Added mximportddl Utility on page 5-99.
•
Updated the description of SAMPLE Clause on page 7-8.
•
Added the attribute MEMORY_USAGE_SAFETY_NET and its description on page
10-61.
•
Added the attribute RECOMPILE_ON_ PLANVERSION_ERROR and its
description on page 10-70.