SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-31
LOAD Command
You can specify both MOVE and MOVEBYNAME. For fields where the two options
conflict, MOVE overrides MOVEBYNAME.
If MOVEBYNAME is ON, a DDL group representing a variable-length character
string can be loaded. For more information, see Conversion of DDL Elementary
Items on page C-103 under CONVERT.
MOVEBYNAME OFF is the default.
MOVEBYORDER [ ON | OFF ]
specifies whether fields in the source are loaded to fields in the target on the basis
of position. Data is loaded from the first field of the source record to the first field of
the target record (row), from the second source field to the second target field, and
so forth.
If you specify MOVEBYORDER ON, you cannot specify either the MOVE option or
MOVEBYNAME ON.
If MOVEBYORDER is ON, a DDL group representing a variable-length character
string can be loaded. For more information, see Conversion of DDL Elementary
Items on page C-103.
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,