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.