RE: Any way to find what programs reference specific fields

[Rob Berendt <rob@xxxxxxxxx>]

A couple of options are:

1:  To buy a package.  Several have already been mentioned.
2:  Try to derive something from DSPPGMREF, however I don't think that drills down to the column level.
3:  Try to roll your own to analyze source.
4:  Try to use audit journals to record when/where certain columns are touched.  I'd have to look further to see if that can be drilled down to the column level.
5:  Use triggers to record such stuff.
6:  Get REALLY good at DMPOBJ.  Try one on a program you know modifies a column and search the resultant spool file for that column.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon Hamberg
Sent: Wednesday, April 10, 2019 3:46 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Any way to find what programs reference specific fields

Hi

What you describe is generally a cross-reference application - Sequel Software's Abstract and Hawkeye's Pathfinder and Fresche' X-Analysis (I
believe) and MDXREF are 4 that run on IBM i - they scan source for variables that come from tables and all - these are not cheap.

It might be possible parse the cross-reference output of compilations.

And you can use some general-expression to isolate full words - there might even be an option for that in your search tool - but something that can say give me results where the character just before the value is not a letter or number - same for the character just after - that isolates it as "full word" - someone please tune this up if I'm off some.

HTH
Vern

On 4/10/2019 1:55 PM, smith5646midrange@xxxxxxxxx wrote:
> I am trying to find all of the programs that reference particular field
> names from particular files.  I need to look at RPG and CL (all flavors of
> both).
>
>   
>
> For example, I am trying to find all of the references to the field "ACCT".
> When I try to scan source, I found values like CUSTACCT, ACCTDESC, GLACCT,
> etc.  I can't scan for it with a space before or after or I miss
> "%trim(ACCT)".  I know I can narrow it down by doing a DSPPGMREF of each
> program and eliminate all programs that don't reference the file but that is
> still a log of programs and the number of files and fields that I need to do
> this for is huge.  Are there any commands that would let me see field names
> used inside of a program.