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

Eric,

Isn't this what tools like Hawkeye or Abstract/Probe are for?

If the source is all fixed format RPG you can, fairly easily, write your own RPG parser to list the field usage in the program (factor 1, factor 2, factor 3, data structure, input spec, output spec). One of the benefits of old school fixed format RPG - it's easy to parse.

Paul Morgan

Principal Programmer Analyst
IT Supply Chain/Replenishment

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