× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. August 2011

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


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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.