beautypg.com

HP NonStop G-Series User Manual

Page 163

background image

NonStop AutoTMF Software Commands

HP NonStop AutoTMF Software User’s Guide429952-014

6-89

UPDATE

COUNT num-records

is the number of records or rows to be copied. If omitted, all records are copied

EXACT

requests exact positioning on the record key (primary or alternate) specified in
the FIRST KEY option.

FIRST { ordinal-record-num }
{ KEY { record-spec | key-value } }
{ key-spec ALTKEY key-value [, key-value ] }

the starting record of the input file to update. If omitted, the update 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 is 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 ]

This manual is related to the following products: