NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-30
LOAD Command
MOVEBYORDER ON is the default.
TRUNC[ATION] [ ON | OFF ]
specifies whether to truncate data from a source field that is longer than its target
field.
If TRUNC OFF is in effect, LOAD reports an error if a source field is longer than its
target field.
TRUNC OFF is the default.
REDEFINE ( redefine-spec [ , redefine-spec ] ... )
redefine-spec is:
original-qualified-name AS redefined-qualified-name
specifies that original DDL items (groups or fields) are loaded to columns based on
redefinitions of the items. If you load from a table to a file, columns are loaded to
DDL items based on redefinitions.
Unless you include the REDEFINE option, all redefined items are loaded according
to the original definition of the original items.
original-qualified-name
identifies an original field or group in a DDL record. The name must be qualified by
the group names at all preceding levels. For example,
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.