RE: Seeing a member list using System i Navigator

I don't see a way using the schema views but the following query can be used to see a list of them. In the schema view I have to add the library to the list then expand the tables until the list of files is resolved. It might take some time if there are a lot of members as its building a summary from the source file of all them member records inside. I don't see a way to drill into a member list from there.

select * from SYSPARTITIONSTAT
where ( TABLE_SCHEMA = CURRENT_USER OR TABLE_SCHEMA in ( SELECT SCHEMA_NAME FROM QSYS2.LIBRARY_LIST_INFO ) )
-- and SOURCE_TYPE = ''
-- and TABLE_PARTITION = '' -- member name
and table_schema = 'xxxx'
and TABLE_NAME = 'sssss'
order by TABLE_SCHEMA
;


-Matt

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bill Howie
Sent: Tuesday, December 5, 2017 12:44 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Seeing a member list using System i Navigator

Hello all,

Can anyone tell me if there is a way to view a list of members for a physical file within System I Navigator? I know how to do it via green-screen, but some of my colleagues only have Navigator set up and have the need to know if a file is multi-member or not. Thoughts? Thanks in advance!

Bill Howie



AOMobile - AmTrust Financial Services, Inc. Download on the App Store?<https://urldefense.proofpoint.com/v2/url?u=https-3A__itunes.apple.com_us_app_aomobile_id626262396-3Fmt-3D8-26uo-3D4&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WvSdlJlGB2UOWJxGjyzv7Tau9aYGkrwBLiuAxOZ7B64&s=IG403o1TL4wD0RzvG1YLciihytwO8symW6mWBvRjlOM&e=> | Get it on Google Play(tm)<https://urldefense.proofpoint.com/v2/url?u=https-3A__play.google.com_store_apps_details-3Fid-3Dcom.amtrust.aomobile&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WvSdlJlGB2UOWJxGjyzv7Tau9aYGkrwBLiuAxOZ7B64&s=YlkAlOua5xmC1RjtZ5nwdXD-jlEpc8rNThB3YCICfBk&e=>
- Apple and the Apple logo are trademarks of Apple Inc., registered in the U.S. and other countries. App Store is a service mark of Apple Inc.
- Android is a trademark of Google Inc.

________________________________
Confidentiality Notice: This email message is intended only for the individual or entity to which it is addressed. This email may contain information that is proprietary or privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you received this email by accident, please notify the sender immediately and destroy this email and all copies of it.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WvSdlJlGB2UOWJxGjyzv7Tau9aYGkrwBLiuAxOZ7B64&s=XwLEFlmMqjGdkjoeUtymOocb-LMQvBApqOtzm4NVsyw&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WvSdlJlGB2UOWJxGjyzv7Tau9aYGkrwBLiuAxOZ7B64&s=CqphUfvHCSLbFeVseXpHfgtYHVytyIVDlAEa0Dx19cU&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=WvSdlJlGB2UOWJxGjyzv7Tau9aYGkrwBLiuAxOZ7B64&s=gIjzJJ7djHh0kf6Xh8CZuejlHHdW_1bNojlLguarAU0&e=