Re: Determining which fields are updated or written in a program

Hi Eric

Some tools might recompile, as others mentioned. But they also go direct to source and analyze lines close to other lines, as well as follow variables and parameters through their calls. Yes, you could do it yourself - do you have that much time?

HTH
Vern

On 8/23/2011 1:04 PM, Eric Wolf wrote:

My thought was that if those tools can do it, so can I. They can't be recompiling all programs as a part of their tools. I should have access to the same stuff that they are using, right? Regarding recompiles, what if the programs have to have some OVRDBF done before the compile is done...


Eric

To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Determining which fields are updated or written in a program
From: Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
Date: Tue, 23 Aug 2011 11:24:35 -0500

Or Hawkeye Pathfinder or Databorough's X-Analysis...



From: Alan Campin<alan0307d@xxxxxxxxx>
To: "RPG programming on the IBM i / System i"<rpg400-l@xxxxxxxxxxxx>
Date: 08/23/2011 11:22 AM
Subject: Re: Determining which fields are updated or written in a
program
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



I think the only way to really get everything is to use a 3rd party app
like
Total or Abstract. They have had to write a lot of code to figure this
out.

On Tue, Aug 23, 2011 at 10:11 AM, Alan Shore<ashore@xxxxxxxx> wrote:

Hi Eric
Point taken

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [

mailto:rpg400-l-bounces@xxxxxxxxxxxx]

On Behalf Of Eric Wolf
Sent: Tuesday, August 23, 2011 12:00 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Determining which fields are updated or written in a

program

Alan,
I was hoping that I did not have to recompile (potentially) hundreds of
programs to retrieve that information. What I am trying to do is to

analyse

a company's custom programs that are using a software database to assist

in

the conversion process. If I can see what programs are accessing

specific

files (which I can get from the DSPPGMREF) and then further define which
fields are actually being used, I can increase my productivity for the
project.

I was hoping that the information was stored somewhere that could be
accessed. Not only would recompiling be a monumental task, it would be
impossible to know what parameters were used to compile the programs for
binding, sqlrpgle, etc.

Eric

Date: Tue, 23 Aug 2011 09:12:54 -0430
Subject: Re: Determining which fields are updated or written in a
program
From: luisro58@xxxxxxxxx
To: rpg400-l@xxxxxxxxxxxx

Alan,

I wonder if it would be always as simple as that. What happens if the
field is modified using embedded SQL statements? AFAIK, it wouldn't
appear as M in the XREF info..

Of course, as always, it would depend on the OP's particular needs and
requirements (maybe SQL is not a factor in his case)

Regards,

Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--



On Mon, Aug 22, 2011 at 4:19 PM, Alan Shore<ashore@xxxxxxxx> wrote:

Hi Eric
Maybe I'm missing something, but wont a programs XREF in the compile
listing give you where a field is defined (D) and modified (M)?

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Eric Wolf
Sent: Monday, August 22, 2011 4:35 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Determining which fields are updated or written in a
program


To the list,
Is there any API that could retrieve a list of field usage within a
program. I am looking for a way to determine what fields a program
is updating or writing.

Thanks...
Eric A. Wolf
--
This is the RPG programming on the IBM i / System i (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,

unsubscribe,

or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.