Navigational DML Programming Techniques › Retrieving Records

Retrieving Records

In the navigational environment, you can use the following navigational DML statements to retrieve database records:

• FIND locates a record occurrence in the database.
• GET moves the data associated with a record occurrence from the page buffers to program variable storage.
• OBTAIN locates a record occurrence in the database and moves the data associated with that occurrence to program variable storage (the equivalent of a FIND followed by a GET).
• RETURN retrieves the db-key and the symbolic key for an indexed record without retrieving the record itself.

The DML retrieval functions listed below are discussed on the following pages:

• Accessing CALC records
• Walking a set
• Accessing a sorted set
• Performing an area sweep
• Accessing owner records
• Reestablishing run-unit currency
• Accessing a record by its db-key
• Accessing indexed records
• Moving contents of a record occurrence