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

Jerry,

I was using the STRSQL and copied Robs statement just like he had it.
I was wondering if there was a ptf to install to get that system
table. I see that it is a PTF that Bryan has referenced for me. I
will check to see if that PTF is installed on this system.

Thanks

Jim

On Thu, Sep 25, 2008 at 1:46 PM, Jerry Adams <Jerry@xxxxxxxxxxxxxxx> wrote:

I'm on V5R4, Jim, and it's there. But notice that Rob used SQL-naming. If you do a WRKOBJ, you won't find it. However, if you run STRSQL and prompt, you will find it. Also, iNav will find it. The i5 name is SYSPSTAT, which is an LF. The parent is Partition_Statistics, also in QSYS2.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Essinger
Sent: Thursday, September 25, 2008 1:59 PM
To: Midrange Systems Technical Discussion
Subject: Re: Finding a member in a file, not knowing the file it's in!

Rob,

My system does not lie the SYSPARTITIONSTAT table. Where did that
come from, if you remember?

Jim

On Thu, Sep 25, 2008 at 12:45 PM, <rob@xxxxxxxxx> wrote:

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.

--
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.