Owner manual

SDR Commands
HP NonStop SQL DDL Replicator User’s Guide—545799-005
6-24
COPY
COUNT num-records
the number of records or rows to be copied. If omitted, all records are copied.
FIRST ordinal-record-num
the starting record of the input file to copy. If omitted, the copy starts at the first
record or row in the input file.
ordinal-record-num
the number of records or rows from the beginning of the file that are to
be skipped. The first record in a file is record zero.
KEY { record-spec | key-value }
the primary key value for the starting record or row of a structured disk file.
record-spec is an integer on the range of 0 to 4294967295.
°
for unstructured files, record-spec is the starting relative byte address.
°
for relative files, record-spec is the starting record number
°
for entry-sequenced files, record-spec is the ordinal-record-number
key-value applies only to key-sequenced files and specifies the
approximate position of the starting record; key-value is specified as a
string or as integer byte values in the range of 0 to 255.
The key-value is entered as follows:
"[" { string } [, { string } ] "]"
{ 0:255 } [ { 0,255 } ]
where the integers represent the byte values. To specify a list of strings,
enclose each string in quotation marks separated by a comma and enclose
the list in square brackets.
key-specifier
the alternate key tag (a 2-byte string or a 16-bit integer) designating the
alternate key to be used for positioning.
ALTKEY key-value [, key-value ]
the alternate key of the starting record or row. The format of key-value is
described above.
UPSHIFT
convert lowercase characters to uppercase.
in-options
BLOCKIN n