NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-20
LOAD Command
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 Enscribe file.
out-file
is the name (or an equivalent DEFINE) of an existing SQL table or Enscribe file 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.
Nonconvertible records include records that contain one or more of the following:
•
A nonnumeric value in a numeric field
•
A duplicate key value in the primary key field of the output file
•
A null value when the target field cannot represent a null value
•
Parity errors
•
An ordering that does not match the sort criteria for the output file (only if you
specified SORTED)
•
Inconsistencies with constraints defined for the output table
See CONVERT Command
on page C-89 for more detailed rules for data
conversion.
COUNT num-records
specifies the number of records to load. The default is all records.
EMPTYOK
directs LOAD to accept an empty input file that results in an empty output file. If
the input file is empty and you do not specify EMPTYOK, LOAD terminates and
reports an error without overwriting an existing output file.
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.