Is there a system table that lists members?

[gcraill]

Is there a system table that lists members on the system?

I've had a look at a few files in QSYS2 and SYSIBM but they don't seem to have member information.

[tomholden]

Re: Is there a system table that lists members?

not sure if it encompasses everything but take a look at SYSPSTAT in SYSIBM

[jamief]

Re: Is there a system table that lists members?

If that doesnt work here is an old program from the 70's that might help

http://www.code400.com/forum/showthread.php/1671-list-members-in-iseries-table

Jamie

[gcraill]

Re: Is there a system table that lists members?

Thanks Tom, That has it sorta.

This runs sweet as;

SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER
FROM sysibm/SYSPSTAT where SYSTEM_TABLE_NAME = ''

This runs as fast as a galapogas turtle up a tree;

SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER
FROM sysibm/SYSPSTAT where SYSTEM_TABLE_MEMBER = ''


Obviously no key in the logical on the view for member name.

[tomholden]

Re: Is there a system table that lists members?

views don't have keys