Re: Finding a member in a file, not knowing the file it's in!

This works great!

SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER

FROM QSYS2.SYSPARTITIONSTAT WHERE SYSTEM_TABLE_NAME LIKE 'QRPG%'

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Jim Lowary" <jlowary@xxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/25/2008 10:21 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
Finding a member in a file, not knowing the file it's in!






Does anyone know of a way to find a specific member name in a file?
Trick is I don't know the file it could be in. Not to mention I've only
been here for about 3 months and still finding my way around the maze.
For some reason we have lost the source to a program that has not been
compiled since 2002 and I need to see if some one archived it into
another source file before deleting it.



I've looked at WRKOBJPDM and doing an option "25" but that only scans
the date in the member (all I care about is finding the member name).
Plus the WRKOBJPDM does not put its list to a file so I'd have to go the
API route (or DSPOBJD for *file and then DSPFD for *mbrlist), which I
might have to anyway, just to get a listing of all members in a file, of
OBJATR('PF-SRC').



Thanks for any suggestions you might have.



-- Jim Lowary



--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.