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

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-48
Default Attributes
For more information, see the description for the individual attribute.
TIMEOUT Default time to wait for a
lock before NonStop
SQL/MX returns a timeout
error.
Locking on page 10-57
UNION_TRANSITIVE_PREDICATE
S
Controls the union
transitive predicates.
Query Optimization and
Performance on
page 10-66
UDR_JAVA_OPTIONS
Specifies JVM startup
options for the Java
environment of an SPJ.
Stored Procedures in
Java on page 10-80
UPD_ORDERED
Controls whether rows
must be inserted,
updated, or deleted in
clustering key order.
Query Optimization and
Performance on
page 10-66
UPD_ABORT_ON_ERROR
Controls whether an
update, insert, or delete
function is aborted if an
error occurs.
Statement Atomicity
on
page 10-78
UPD_SAVEPOINT_ON_ERROR
Controls whether DP2
savepoints should be
used and if the transaction
should be aborted in case
of an error.
Statement Atomicity on
page 10-78
VARCHAR_PARAM_
DEFAULT_SIZE
Controls the allowable
length of an untyped
parameter, which is typed
as VARCHAR during the
compilation of a query.
Table Management on
page 10-81
ZIG_ZAG_TREES
Enables or disables the
optimizer to consider zig-
zag trees in addition to
linear trees.
Query Optimization and
Performance on
page 10-66
Attribute (page 9 of 9) Description Category