@FIND/@OBTAIN Statements—accesses database records

The @FIND and @OBTAIN statements are used to access database records:

@FIND locates a record occurrence in the database, but does not move it into program variable storage.
@OBTAIN locates the record occurrence in the database and moves it into program variable storage.

Six formats

@FIND and @OBTAIN have six different formats:

@FIND/@OBTAIN CALC/DUPLICATE accesses a record occurrence using its CALC-key value.
@FIND/@OBTAIN CURRENT accesses a record occurrence using previously established currencies.
@FIND/@OBTAIN DBKEY accesses a record occurrence using a db-key that was previously saved by the program.
@FIND/@OBTAIN OWNER accesses the owner of a set occurrence.
@FIND/@OBTAIN USING SORT KEY accesses a record occurrence in a sorted set, using its sort-key value.
@FIND/@OBTAIN WITHIN SET/AREA accesses a record occurrence based either on the record's logical location in a set or on its physical location in an area.

Each of these @FIND/@OBTAIN statements is discussed on the following pages.