Access path — is roughly equlivant to as SQL index.
If a physical file is keyed it will have two access paths -
the keyed path and the sequential path.
– Your question was about each member — IBM assumed that since seperate members were
created they would be accessed seperately. For native access – RPG/COBOL you can specify
the member(s) to use with the OVRDBF. The members selected will appear to have a single
access path. How this actually works or did they have a single path all along, I don’t know.
With SQL the member is selected with the CREATE ALIAS command but that is limited to one member.
A view could union the alias(s).
AS/400 developers have used members where SQL developers would have included another key field.