SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-24
LOAD Command
BLOCKIN in-block-length
specifies the length of an input block in bytes. in-block-length is a value from
1 through 32,767 that indicates the actual number of bytes requested in a single
physical read operation.
BLOCKIN does not apply to a table unless you specify the UNSTRUCTURED
option. If the input block length exceeds the input record length specified in the
RECIN in-record-length option, input records are deblocked. Records of the
specified length are extracted from the input block until the number of bytes
extracted equals the block length or until the last input record is read.
The read record count for all but possibly the last record in a block is equal to
in-record-length. If the input block length is not an even multiple of
in-record-length, the last record extracted from a full block is a short record
with a read count equal to the number of bytes extracted.
If you omit the BLOCKIN option and in-file is not a labeled tape, SQL uses the
RECIN record length for the block length and reads each input record in a separate
physical operation.
If in-file is a labeled tape, you can specify the input block length with either the
BLOCKIN clause of the LOAD command (as described here) or with the
BLOCKLEN attribute of the CLASS TAPE DEFINE for the tape. If you specify
values for both the BLOCKIN clause and the BLOCKLEN attribute, the values must
match.
{ COMPACT | NO COMPACT }
(for loading from files or tables with relative file organization only) controls whether
zero-length (empty) records on files or tables with relative file organization are
ignored when a file is read. COMPACT ignores empty records and renumbers
records that follow an empty record; NO COMPACT copies empty records. The
default is COMPACT.
For information about the impact of changes in SYSKEY, see Syskeys on
page S-90.
EBCDICIN
(for loading from non-SQL objects only) translates EBCDIC characters to their
ASCII equivalents in the input file. If you omit EBCDICIN, LOAD does not translate
input.
In a conversion between ASCII and EBCDIC, the symbols representing each
character are the same in ASCII and EBCDIC except for:
ASCII EBCDIC
Exclamation point Logical OR