HP NonStop G-Series - Manual (Page 122)

NonStop AutoTMF Software Commands
HP NonStop AutoTMF Software User’s Guide—429952-014
6-48
COPY
FIRST { ordinal-record-num }
{ KEY { record-spec | key-value } }
{ key-spec ALTKEY key-value [, key-value ] }
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. The maximum value is
4294967295.
KEY { record-spec | key-value }
the primary key value for the starting record or row of a structured disk file.
record-spec is a fixed quantity limited to 2**63 -1.
°
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 iis the 64-bit numeric record key
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-spec
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.
FROMLAST
position on the last record in the key range specified in the FIRST KEY option.
UPSHIFT
convert lowercase characters to uppercase.