Re: How to get the Physical file member name when reading a logical member that is based on multiple physical members

I would first ask myself if and why I needed that information. Asking the question /Whence is the data?/ should be a harbinger of a design flaw being exposed, similar to asking the question /Who called me?/. Very limited application sets should need to know either. Why would the program making access to the database need to be aware of the underlying implementation of the data storage and retrieval, other than the record layout of the data? What if a member is renamed or other restructuring of the underlying database is effected? A dependency coded into the program with regard to such information extracted at run-time might cause the program to break, given any such changes to the database.

Warning: There is no specific number for members of a file. There is however a number for which dataspace _of_ a logical member. Thus I would expect that the QUSRMBRD API would be used on the logical member, to get the desired information. That API should provide the list of underlying data members, and the physical-file-member-number would be the index into an array of data members. The /array/ of data members should be the same as what the DSPFD for TYPE(*MBR) information [but for one member versus all] which is /Number of data members/ followed by the list of /Based on file/ defined under that logical member.

Regards, Chuck