SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-30
LOAD Command
TARGETDICT dictionary-name
specifies the subvolume containing the DDL dictionary that contains the DDL
record or DEF definition for an Enscribe output file. dictionary-name is a
Guardian subvolume name.
If you omit the TARGETDICT option, LOAD assumes that the dictionary resides on
the current default subvolume.
TARGETREC record-name
(for loading non-SQL objects only) specifies the DDL record name of the record or
DEF definition for outfile.
If you omit the TARGETREC option, SQL assumes that fields in out-file occur
in the same order as fields or columns in in-file and that all variable-length
character fields are expanded to the maximum length and padded with blanks. For
information about how LOAD converts other data types if they are not explicitly
defined, see the Data type compatibility and field conversions item under
Considerations—LOAD on page L-33.
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 a
non-SQL object, 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 a non-SQL
object, 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.