Overview of FIND/OBTAIN

Database Access Commands › Navigational DML › Overview of FIND/OBTAIN

Overview of FIND/OBTAIN

The FIND command is used to locate a record occurrence in the database. The OBTAIN command is used to locate a record and move the data associated with the record to a dialog's record buffers. Because the FIND and OBTAIN command statements have identical formats, they are discussed together.

There are six formats of the FIND/OBTAIN statement, as outlined below.

Formats of the FIND/OBTAIN Statement

Format	Description
FIND/OBTAIN CALC	Accesses a record occurrence by using its CALC key value
FIND/OBTAIN CURRENT	Accesses a record occurrence by using established currencies
FIND/OBTAIN DB-KEY	Accesses a record occurrence by using its database key
FIND/OBTAIN OWNER	Accesses the owner record of a set occurrence
FIND/OBTAIN WITHIN SET/AREA	Accesses a record occurrence based on its logical location within a set or on its physical location within an area
FIND/OBTAIN WITHIN SET USING SORT KEY	Accesses a record occurrence in a sorted set by using its sort key value

Considerations

Locks can be placed on located record occurrences by using the KEEP clause of a FIND/OBTAIN statement. The KEEP clause sets a shared or exclusive lock.
- KEEP places a shared lock on the located record occurrence. Other concurrently executing run units can access but not update the locked record.
- KEEP EXCLUSIVE places an exclusive lock on the located record occurrence. Other concurrently executing run units can neither access nor update the locked record.