SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-25
LOAD Command
The conversion is done without regard to the data types of fields or columns of the
input, so undesired changes to the data can occur if you use EBCDICIN with input
that is not composed of simple character data.
RECIN in-record-length
specifies the maximum length of an input record in bytes. The actual number of
bytes in each input record (the read count) depends on whether you also specify
TRIM:

If you do not specify TRIM, the read count is the actual number of bytes in the
input record. (For unstructured files that are not EDIT files, the read count is
exactly in-record-length bytes, although fewer bytes might be read from
the last record; for all other files, the read count is the number of bytes actually
read.)

If you specify TRIM, every trailing trim-character is deleted from the input
record. The read count includes only the characters that have not been
trimmed.
If you omit RECIN, SQL determines in-record-length:

If you specify in-block-length as less than or equal to 4096, the value of
in-record-length is used for in-block-length. If in-block-length
is greater than 4096, in-record-length is 4096.

If you do not specify in-block-length,

If in-file is a structured disk file or a nondisk device, in-
record-length is the record length specified or calculated when the file
was created (or when the system was generated).

If in-file is an unstructured disk file, and if out-file is a table and you
do not specify VARIN, in-record-length is the length of the logical
record specified by SOURCEREC or—if you do not specify
SOURCEREC—the length of the logical record implied by the description
of the output table; otherwise, in-record-length is 132.

If in-file is a process, in-record-length is 132.
RECIN does not apply to a table unless you specify the UNSTRUCTURED option.
If in-file is a labeled tape, you can specify the input record length with either the
RECIN clause of the LOAD command (as described here) or with the RECLEN
attribute of the CLASS TAPE DEFINE for the tape. If you specify values for both
the RECIN clause and the RECLEN attribute, the values must match.
Left square bracket Cent sign
Right square bracket Exclamation point
Circumflex Logical NOT sign
ASCII EBCDIC