Re: Where used issue

Phil,
Build a file of programs using the changed file and then exclude all the
programs that have not been used using the dspobjd output file.
You can use SQL to delete those records where the days used is zero.
Be carefull that you do not delete a program that was created that is used
rarely (eom, quarterly, end of year, etc.).

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer
V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3









----- Original Message ----
From: Phil Kestenbaum <pkestenbaum@xxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, June 15, 2007 2:35:15 PM
Subject: RE: Where used issue


Jeff, what I am trying to do is to relate a file that has now been
changed with all of the objects that it touches but only insofar as
these objects have been used.

I suppose this is just making the case for not allowing anything with a
0-used days to reside in Production.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Friday, June 15, 2007 11:20 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Where used issue

Phil,
You might try running a dspobjd of all the programs in the libraries you
are interested in to an output file and the selecting only those
programs that had a value other than 0 in the number of days used count.

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3









----- Original Message ----
From: Phil Kestenbaum <pkestenbaum@xxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, June 15, 2007 9:39:53 AM
Subject: Where used issue


HI I am looking at RPG programs that may have to be modified, using the
Abstract probe tool. But it would be beneficial to know if an Program in
the group was ever used. Even using FNDSTRPDM will not allow this
filter. As I see it, this is a manual process of getting a list of
programs or file that may have to be modified and then running the
command DSPOBJD on each one to see when if ever this object has been
used.



Is there another way to get a list of where-used that would leave out
the ones that were never used?



Thank you,

Phil


This message contains information proprietary to our company. It is
intended to be read only by the individual or entity named above or
their designee.
Any distribution of this message or the information contained herein
without written permission from our company is strictly prohibited. If
the reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately by e-mail, and delete the original message.