SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-27
LOAD Command
{ UNLOADIN | NO UNLOADIN }
(for loading from a magnetic tape only) specifies whether the tape is unloaded
when rewinding occurs. The default is UNLOADIN (the tape is unloaded when
rewound).
VARIN
(for loading only from files—not tables—with variable-length, blocked records, such
as those produced using the VAROUT option of COPY) tells LOAD that in-file
contains variable-length, blocked records that begin with a word that contains the
length of the record; the read count equals the value of that length indicator.
key-sequence-option
specifies how to load tables or files with key-sequenced file organization.
{ PARTONLY }
{ PARTOF volume-name }
(for loading files or tables with key-sequenced file organization only) directs SQL to
load only a single partition. PARTONLY affects only the output and has no effect on
how SQL reads the input file.
For an SQL table, PARTONLY directs SQL to load the partition specified as
out-file while PARTOF directs SQL to load the partition on volume
volume-name. If you specify PARTOF, you can specify any partition of the table
as out-file.
For a non-SQL object, PARTOF directs SQL to load the partition specified as
out-file. volume-name must specify the volume that contains the primary
partition. You cannot use PARTONLY with a non-SQL object.
You cannot use PARTONLY or PARTOF if the table has indexes defined for it. You
cannot use PARTONLY for an audited table if BLOCKSIZE is less than 2KB.
PARTONLYIN
(for loading files or tables with key-sequenced file organization only) directs SQL to
load only from a single partition. PARTONLYIN affects only the input and has no
effect on how SQL writes the output file.
For an SQL table and non-SQL object, setting the PARTONLYIN option directs
SQL to load from the partition specified as in-file.
SORTED
(for loading files or tables with key-sequenced file organization only) specifies that
input file records are already sorted in the key-field order of the output file and are
not to be resorted. If you omit this option and the target file is key-sequenced,
LOAD sorts the records before loading the output file.