Reading database records using an arrival sequence access path

 

These read operations are allowed if the file is defined with an arrival sequence access path, or if the file is defined with a keyed sequence access path, but you choose to ignore the keyed sequence access path.

The system performs the read operations based on the operations that you specify using your high-level language. Your high-level language might not allow all of the following read operations. See your high-level language topic collection to determine which operations are allowed.

• Reading next operation
  This operation positions the file to the next record that is not deleted in the arrival sequence access path and gets that record.

• Reading previous operation
  This operation positions the file to the previous active record in the arrival sequence access path and gets that record.

• Reading first operation
  This operation positions the file to the first active record in the arrival sequence access path and gets that record.

• Reading last operation
  This operation positions the file to the last active record in the arrival sequence access path and gets that record.

• Reading same operation
  This operation gets the record that is identified by the current position in the file. The file position is not changed.

• Reading by relative record number operation
  This operation positions the file to the record that is identified by the relative record number in the arrival sequence access path and gets that record.

 

Parent topic:

Reading database records

 

Related concepts

Ignoring the keyed sequence access path