SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-120
COPY Command
out-block-length is greater than 4096, out-record-length is
4096.

If you do not specify out-block-length and if out-file is an
unstructured disk file, if in-file is an SQL table, VAROUT is not
specified, and no display option was specified, out-record-length is
the length of the logical record specified by TARGETREC, or—if
TARGETREC is not specified—the length of the logical record implied by
the description of the input table. Otherwise, out-record-length is 132.

If you do not specify out-block-length and if out-file is a process
file, out-record-length is 132.

If you do not specify out-block-length and if out-file is a structured
disk file or a nondisk device, out-record-length is the record length
specified or assigned when the file is created (or when the system is
generated).
If out-file is a labeled tape, you can specify the output record length with
either the RECOUT clause of the COPY command (as described here) or with
the RECLEN attribute of the CLASS TAPE DEFINE for the tape. If you specify
values for both the RECOUT clause and the RECLEN attribute, the values
must match.
{ REWINDOUT | NO REWINDOUT }
(for copying to magnetic tapes only) specifies whether to rewind the tape when
COPY completes. The default is REWINDOUT (the tape is rewound).
SKIPOUT num-eofs
(for copying to unlabeled magnetic tapes only) moves the tape past num-eofs
end-of-file (EOF) marks before starting to copy the 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 backwards over
(-1 times num-eofs) EOF marks, moved forward so that it is positioned
immediately ahead of the last EOF mark passed.
If you specify a value of 0 for num-eofs, the SKIPOUT option is ignored.
If you omit the SKIPOUT option, the tape remains at its current position, and data
transfer begins with the next physical record on tape.