SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-50
Partition Management
the current physical location. SET MPLOC changes the values for default
attributes MP_SYSTEM, MP_VOLUME and MP_SUBVOLUME.
Use the SET MPLOC statement in MXCI. For embedded SQL, the SET
MPLOC statement affects only dynamic embedded SQL. The DECLARE
MPLOC statement affects only static embedded SQL.
•
For SQL statements issued through MXCI and embedded SQL, the compiler
uses the MP_SYSTEM, MP_VOLUME or MP_SUBVOLUME values set by
CONTROL QUERY DEFAULT statements (if issued).
3. For SQL statements issued through MXCI and embedded SQL, the compiler uses
the MP_SYSTEM, MP_VOLUME or MP_SUBVOLUME values in the
SYSTEM_DEFAULTS table (if they exist).
4. For SQL statements issued through MXCI and embedded SQL, if these values are
not set, the system-defined default setting for $volume.subvol is specified by
the =_DEFAULTS define.
The TACL command INFO DEFINE =_DEFAULTS can be used to look at the
default volume and subvolume for the current TACL session. For information on
the =_DEFAULTS define, see the Guardian Programmer’s Guide.
Partition Management
These attributes are used by NonStop SQL/MX for partition management:
Attribute Setting
DDL_DEFAULT_
LOCATIONS
Physical location of the primary range partition to be created
by CREATE statements that do not specify 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 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 a LOCATION clause and you have specified this
default, the location of the catalog's metadata 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 (" "), SQL/MX
uses the value of the =_DEFAULTS environment variable (the
default volume) for the metadata location.
The default is no specification.
Note: This attribute is available only to systems running
NonStop SQL/MX Release 2.1.0 (SPR equivalent is ABU.)