SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-26
LOAD Command
REELS num-reels
(for loading from an unlabeled magnetic tape only) sets the number of reels that
make up the input file. Specify num-reels as an integer from 1 through 255. The
tape is read until two consecutive EOF marks are reached for num-reels. At each
end of reel before the last reel, the tape is rewound and unloaded, and you are
prompted for the next reel. If you omit REELS, in-file data transfer terminates
when a single EOF mark is encountered.
{ REWINDIN | NO REWINDIN }
(for loading from a magnetic tape only) specifies whether the tape is rewound when
the end of file is read from tape. If you specify NO REWINDIN, the tape remains
positioned. The default is REWINDIN.
SHARE
(for loading from disk only) opens in-file in shared exclusion mode. Using
SHARE, you can access an in-file even if it is currently open by another
process, unless that process is open with exclusive exclusion mode. If you omit
SHARE and in-file is a table or disk file, LOAD opens in-file with protected
exclusion mode. The SHARE option cannot use certain internal performance
features and, therefore, might perform more slowly than a LOAD request without
the SHARE option.
SKIPIN num-eofs
(for loading from an unlabeled magnetic tape only) moves the tape specified as
in-file past num-eofs end-of-file marks before starting to transfer data. Specify
num-eofs as an integer from -255 through 255.

If you specify a positive value for num-eofs, the tape is wound forward past
num-eofs EOF marks and is positioned immediately after the last EOF mark
passed.

If you specify a negative value for num-eofs, the tape is wound backward
over (-1 times num-eofs) EOF marks, then moved forward and positioned
immediately ahead of the last EOF mark passed.

If you specify a value of zero for num-eofs, the SKIPIN option is ignored.
If you omit the SKIPIN option, the tape remains at its current position, and the data
transfer begins with the next physical record on tape.
TRIM trim-character
(for loading from a non-SQL object only) deletes any trailing characters in each
record matching trim-character. Specify trim-character as a single ASCII
character inside quotation marks (“c”) or as a numeric literal in the range of 0
through 255 representing the byte value of the character.