SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-21
LOAD Command
Nonconvertible records include records that contain one or more of:

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
For more information about the rules for data conversion, see CONVERT
Command on page C-94.
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.
FIRST { ordinal-record-num }
{ KEY record-spec }
{ KEY (key-value[, key-value] ... ) }
{ key-specifier ALTKEY ( key-value }
{ [ , key-value ] ... ) }
specifies the starting record of the input file from which to begin loading. If you omit
FIRST, the load operation starts with the first record.
ordinal-record-num
is the number of records (from the beginning of the file) to skip. If you specify this
option for an unstructured disk file, the loading begins at this offset:
ordinal-record-num * in-record-length
KEY record-spec
specifies the primary-key value for the starting record of an unstructured file, or of
a relative or entry-sequenced file or table. The record you name with KEY is the
first record to load. Specify record-spec as an integer from 0 through
4,294,967,295.

For unstructured files, record-spec is the starting relative byte address.

For relative files or tables, record-spec is the starting record number.