[[{“value”:”If I wanted to get a list of members in a file with SQL I always had to work with the SYSPARTITIONSTAT View, which was not the purpose it was designed for. In the latest latest Technology Refreshes a new View has been added that is designed for information about members, SYSMEMBERSTAT.
The new SYSMEMBERSTAT View is in the library QSYS2 and contains all the columns I could want to know about members in a file.
I always recommend if this is the first time you are using a View you should look at all of the columns and determine, for yourself, which ones are important. The following statement displays all the columns in SYSMEMBERSTAT:
Read more »”}]] Read More
Get empowered with IBM Power
