SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-20
LOAD Command
in-file
is the name (or an equivalent DEFINE) of the table or file from which to load data.
in-file can be a Guardian process, device (such as a terminal or tape),
unstructured disk file, or non-SQL object.
out-file
is the name (or an equivalent DEFINE) of an existing SQL table or non-SQL object
to load.
ALLOWERRORS [ ON | OFF | num ]
specifies what happens when errors occur.
If you omit the ALLOWERRORS clause completely, the default is
ALLOWERRORS OFF. If you specify ALLOWERRORS but do not specify an
option, the default is ALLOWERRORS ON.
move-option is:
{ SOURCEDICT dictionary-name }
{ SOURCEREC record-name }
{ TARGETDICT dictionary-name }
{ TARGETREC record-name }
{ }
{ MOVE { source-name TO target-name } }
{ { ( source-name TO target-name } }
{ { [, source-name TO target-name]...) } }
{ }
{ MOVEBYNAME [ ON | OFF ] }
{ MOVEBYORDER [ ON | OFF ] }
{ TRUNC[ATION] [ ON | OFF ] }
{ REDEFINE ( redefine-spec [, redefine-spec]...) }
redefine-spec is:
original-qualified-name AS redefined-qualified-name
config-op is:
CONFIG { config-file [ FOR index-name ] }
{ }
{ ( config-file FOR index-name }
{ [, config-file FOR index-name]... ) }
ON skips nonconvertible records but process subsequent records.
OFF stops the load operation after the first conversion error.
num skips nonconvertible records until the number of such records exceeds the
value of num. The maximum value for num is 32,767.