SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-32
LOAD Command
CUSTOMER.ADDRESS.STREET-ADDRESS
is the qualified name of the STREET-ADDRESS field in the ADDRESS group.
The ADDRESS group is in the CUSTOMER group.
redefined-qualified-name
identifies a redefined field or group that corresponds to the original field or group.
The name must be qualified by the group names at all preceding levels. For
example,
CUSTOMER.ADDRESS.STREET-DETAIL
is the qualified name of the STREET-DETAIL field that redefines the
STREET-ADDRESS field.
When the field or group is loaded, the load is based on the redefinition you specify.
PARALLEL EXECUTION { ON [ config-op ] | OFF }
config-op is:
CONFIG { config-file [ FOR index-name ] }
{ }
{ ( config-file FOR index-name }
{ [, config-file FOR index-name]... ) }
specifies whether to load partitions of a partitioned index in parallel. The default
(PARALLEL EXECUTION OFF) is to load partitions sequentially.
PARALLEL EXECUTION ON applies only to one partitioned index at a time. If the
loaded table has more than one partitioned index, the partitions of the first index
are loaded in parallel first. After the first index has been loaded, the partitions of the
second index are loaded in parallel, and so forth. The parallel load index operation,
therefore, loads the partitions of a physical index simultaneously; it does not load
two physical indexes simultaneously.
config-file is the name of an EDIT file that contains instructions for configuring
the processes that load the index. For information about how to specify
configuration instructions in config-file, see Parallel Index Loading
on
page P-5.
FOR INDEX index-name specifies which index to load in parallel using the
configuration in the preceding config-file. index-name is the name of any
partition of the index. Each specified index must be unique.
If you specify only one configuration file in the PARALLEL EXECUTION clause and
omit the FOR index-name clause, the configuration file applies to all indexes for
the loaded table.