Data integrity considerations
These situations can occur unless you lock the physical files that are used by the join logical file.
- Your program reads a record for which there are two or more records in a secondary file. The system supplies one record to your program.
- Another program updates the record in the primary file that your program has just read, changing the join field.
- Your program issues another read request. The system supplies the next record based on the current (new) value of the join field in the primary file.
These same considerations apply to secondary files as well.
Parent topic:
Join logical file considerations