If you use the iSphere Source File Search, you can look over all the source members and use this regex search to only find the exact field you're using.
It won't work if you're using EVAL-CORR and data structures though.
Replace ... with the field you're looking for.
[^A-Za-z0-9_]...[^A-Za-z0-9_]
iSphere uses IBM's regex engine rather than RDI's Java regex engine and doesn't recognize some of the flags like \W.
Michael Salsman
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of smith5646midrange@xxxxxxxxx
Sent: Wednesday, April 10, 2019 13:41
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Any way to find what programs reference specific fields
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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=4Nk_SFisim1opyqr2XrZqsSeGv9o5Q_oWxdaXiG4Eag&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=37xA0aNBB8hbts8xyG_MitnSwDVH8wJnIJlToAkFTrg&e=.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=S5GEfaQPiMAts5Xi7-CXnvlxP-fil_uSkJhudyIr-0E&e=
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=4Nk_SFisim1opyqr2XrZqsSeGv9o5Q_oWxdaXiG4Eag&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=37xA0aNBB8hbts8xyG_MitnSwDVH8wJnIJlToAkFTrg&e=.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=S5GEfaQPiMAts5Xi7-CXnvlxP-fil_uSkJhudyIr-0E&e=
midrange.com
