SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Reviewing and Setting System Defaults
HP NonStop SQL/MX Installation and Management Guide—544536-007
6-6
New System Default for SQL/MX Release 2.3.3
New System Default for SQL/MX Release 2.3.3
Table 6-3 lists the system defaults that are supported by SQL/MX Release 2.3.3 or
later. For more information about these and other system defaults, see the SQL/MX
Reference Manual.
Table 6-2. New System Defaults for SQL/MX Release 2.1
Default Description
DDL_DEFAULT_LOCATIONS The physical location of the primary range partition to be
created by CREATE statements that do not provide a
LOCATION clause, specified as [\node.]$volume.
You can specify multiple locations separated by
commas. If you enter a CREATE TABLE or CREATE
INDEX statement without specifying a LOCATION
clause and you have specified this system default, the
location is determined by picking one volume from the
specified list. If the statement does not have a
LOCATION clause and you do not specify this default or
set it to space (“ “), NonStop SQL/MX uses the value of
the =_ DEFAULTS environment variable (the default
volume) for the partition location.
If you enter a CREATE CATALOG statement without
specifying the LOCATION clause and you have
specified this system default, the location of the
catalog’s metadata is determined by picking one volume
from the specified list.
The default is no specification.
This attribute is available only to systems running
SQL/MX Release 2.1 or later.
Table 6-3. New System Defaults for SQL/MX Release 2.3.3
Default Description
CHECK_CONSTRAINT_
PRUNING
Controls the check constraints pruning optimization.
MULTIUNION Controls the MultiUnion operator.
UNION_TRANSITIVE_
PREDICATE
Controls the union transitive predicates.