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



Nice thought. That made the regex pop into my mind and since they have
added REGEXP_LIKE to SQL, maybe I'll see if that will help me. I'm not good
at regex expressions so I rarely use them and often forget about them.

Thanks.

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



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.