NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-116
COPY Command
•
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, then 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.
{ UNLOADOUT | NO UNLOADOUT }
(for copying to magnetic tapes only) specifies whether the tape is unloaded when
rewinding occurs. The default is UNLOADOUT (the tape is unloaded when it is
rewound).
VAROUT
(for copying to Enscribe files only) writes variable-length, blocked records.
Each Enscribe variable-length record is preceded by a one-word indicator containing
the record length in bytes. The indicator is always aligned on a word boundary,
although records might contain an odd number of bytes. The indicator and the write
count are equal even though the record might have been truncated. Truncation
occurs if the record is longer than out-record-length or out-block-
length minus two. (Two extra bytes are required for the indicator.)
Records cannot span blocks. If the next record with its indicator does not fit into the
current block, VAROUT terminates the current block and begins a new block.