SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-122
Considerations—COPY
SHAREOUT
opens the output file with SHARED access. If you omit SHAREOUT, the output file
is opened with EXCLUSIVE access.
display-option
(for copying to Enscribe files only) specifies the format for displaying the file:
If you do not specify BYTE, COPY handles each word as a single value and
converts it accordingly. If you specify BYTE but not OCTAL, DECIMAL, or HEX, the
display appears in byte-octal format.
If you specify more than one of OCTAL, DECIMAL, and HEX, each line is
displayed in each specified format in the order: octal, decimal, and hexadecimal.
The ASCII option has no meaning when combined with OCTAL, DECIMAL, HEX,
or BYTE.
move-option
specifies names of elements related to the table or Enscribe file and how to map
source names to different target names. move-option is identical to
move-option for the LOAD command. For information on move-option
clauses, see LOAD Command
on page L-18 and for considerations related to
move options, see Considerations—LOAD
on page L-33.
Considerations—COPY

COPY requires authority to read the source file and authority to write to the target
file. If you are copying to or from a table, you must also have authority to read the
catalog in which the table is described.

COPY performs these operations:

From an Enscribe file to a table—each source record from the file is inserted
as a row in the target table. Each elementary field value in the source record is
converted into a column value in the table row generated from the source
record. Values are also copied to the indexes of the table.

From a table to an Enscribe file—each row from the table is added as a record
to the target file. Each column value in the source row is converted to an
elementary field value in the target record.
O[CTAL] Display in octal and ASCII
D[ECIMAL] Display in decimal and ASCII
H[EX] Display in hexadecimal and ASCII.
BYTE Display in byte format and ASCII, convert each byte separately
A[SCII] Display in ASCII
NO HEAD Omit the heading preceding each record