I modified my current SQL statement to include a modified version of the
regex that you provided. I added @#$ to the exclusion string. It looks
like it is doing what I needed.
Heaven help me when the next person takes over this utility that I am
writing and sees that I have regex expressions in the file joins of an SQL
statement. :)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Salsman, Michael
Sent: Wednesday, April 10, 2019 4:01 PM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Any way to find what programs reference specific fields
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_mail
man_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1w
DDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_P
ELWFRetXps7_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_mi
drange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzG
wgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJo
Cj7JA&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=D
wICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8
CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=S5GEfa
QPiMAts5Xi7-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_mail
man_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1w
DDGs&r=ls1vEGzGwgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_P
ELWFRetXps7_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_mi
drange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzG
wgqZJyzZs7sGJ8CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJo
Cj7JA&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=D
wICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=ls1vEGzGwgqZJyzZs7sGJ8
CtK97ty2KqTEwuy7Bm0ek&m=u21X5w7o61ukeWaN9wScR_PELWFRetXps7_kJoCj7JA&s=S5GEfa
QPiMAts5Xi7-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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
