NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-23
LOAD Command
If you omit USESQLNULLS, LOAD provides no special treatment for Enscribe
null characters.
in-option
specifies characteristics of the input file.
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 Enscribe files only) translates ASCII characters to their EBCDIC
equivalents in the output file. If you omit EBCDICOUT, LOAD does not translate
output.