Manualshelf

NonStop SQL/MP Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series
511512513514515516517518519520
Table Of Contents
NonStop SQL/MP Reference Manual—142115
L-24
LOAD Command
In a conversion between ASCII and EBCDIC, the symbols representing each
character are the same in ASCII and EBCDIC except for the following:
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 EBCDICOUT 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, even though 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 as follows:
•
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
ASCII EBCDIC
Exclamation point Logical OR
Left square bracket Cent sign
Right square bracket Exclamation point
Circumflex Logical NOT sign