SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-118
COPY Command
tables and Enscribe files to Enscribe files. The SQLNULLABLE option for Enscribe
to SQL loading automatically enables the USESQLNULLS option.
in-option
specifies characteristics of the input file. It is identical to the in-option for the
LOAD command. For information on in-option clauses, see LOAD Command
on page L-18.
out-option
specifies characteristics of the output file.
BLOCKOUT out-block-length
(for copying to non-SQL files and processes only) specifies the number of bytes in
a block of the output file (the maximum number of bytes written in a single physical
operation).
out-block-length is an integer in the range 1 to 32767 that specifies a
blocksize supported for out-file. (Not all file types support the full range of
blocksizes.)
If the length of the output block is greater than the RECOUT
out-record-length, output record blocking occurs. The block is filled with
out-record-length records until it is full or until the last output record is
encountered.
If the block length is not an even multiple of out-record-length, the last record
in a full block is truncated.
The actual number of bytes written in a physical operation is out-block-length
for all blocks but the last one. If the last block is not full, the actual number of bytes
written is equal to the number of records in the last block times the out-record-
length.
If you omit BLOCKOUT and out-file is not a labeled tape, COPY uses the
RECOUT value for out-block-length and writes each output record in a
separate physical operation.
If out-file is a labeled tape, you can specify the output block length with either
the BLOCKOUT clause of the COPY command (as described here) or with the
BLOCKLEN attribute of the CLASS TAPE DEFINE for the tape. If you specify
values for both the BLOCKOUT clause and the BLOCKLEN attribute, the values
must match.
EBCDICOUT
(for copying to non-SQL files and processes only) translates ASCII characters to
their EBCDIC equivalents in the output file. If you omit EBCDICOUT, COPY does
not translate output.