NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-29
LOAD Command
MOVE { source-name TO target-name }
{ (source-name TO target-name }
{ [,source-name TO target-name ] ... ) }
associates a field of the source with a field in the target so that data from the source
field is loaded into the specified target field. Any column except a system-defined
primary key can be a source or target item.
source-name
is the name of a DDL elementary data field item if you are loading data from an
Enscribe file, or a column name if you are loading data from a table.
target-name
is the name of a DDL elementary data item if you are loading data to an Enscribe
file, or a column name if you are loading data to a table.
You cannot specify a DDL group name (except the VARCHAR group) or the name
of an array of fields in the MOVE option. You can, however, subscript or qualify the
name of a DDL elementary data item. You need to qualify the name if it is
ambiguous.
You cannot specify a system-defined primary key in the MOVE option.
MOVEBYNAME [ ON | OFF ]
specifies whether or not each field in the source record that has the same name as a
field in the target record is copied to the target field with the same name.
The DDL hyphen (-) and the SQL underscore (_) are equivalent.
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-98 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-98.