HP Integrity NonStop J-Series User Manual

Page 166

Advertising
background image

USING AN ENABLE APPLICATION
READ FIRST

If a key field is a group consisting of two fields, a READ FIRST
operation retrieves the first record if the group is a primary
key field or the record with the lowest group value if the group
is an alternate key field. Consider the following group key
field:

+ DEPT
REGNUM __
BRANCHNUM __

If you request a READ FIRST operation by positioning the cursor
in either REGNUM or BRANCHNUM, the application will return the
first existing record with the lowest DEPT value.

If duplicate alternate key values exist when you request a READ
FIRST operation, the application will return a record with the
requested alternate key value and the lowest primary key value.

READ FIRST Operation for an Outermost Box

You can request a READ FIRST operation for an outermost box at
any time by pressing F4.

READ FIRST Operation for a Nested Box

To request a READ FIRST operation for a nested box, do the
following:

1. Request either a read or insert operation for the containing
box.

2. Press F4.

8-13

Advertising
This manual is related to the following products: