RE: Any way to find what programs reference specific fields

TO better yourself at REGEX use this page.
https://regexr.com/
or this one
http://txt2re.com/index-php.php3

-Matt

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of smith5646midrange@xxxxxxxxx
Sent: Wednesday, April 10, 2019 1:41 PM
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=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=SKg8kSam9WTOGGwC2yAwus0Nwm9IqZPy7LFetDXxRhs&s=hN9RQfwUJxrHjqZIA9Byx32bpKq3Y1gGJTIc03nezAo&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=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=SKg8kSam9WTOGGwC2yAwus0Nwm9IqZPy7LFetDXxRhs&s=aRH7_H95CwYWFTh0OM6xHPyaqRg7w8Ckm7gtvPwT0K4&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=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=SKg8kSam9WTOGGwC2yAwus0Nwm9IqZPy7LFetDXxRhs&s=QYzBHD5uA7H8e8q56uDUF25-W6AerO8i4DckVTYRCFg&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=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=SKg8kSam9WTOGGwC2yAwus0Nwm9IqZPy7LFetDXxRhs&s=hN9RQfwUJxrHjqZIA9Byx32bpKq3Y1gGJTIc03nezAo&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=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=SKg8kSam9WTOGGwC2yAwus0Nwm9IqZPy7LFetDXxRhs&s=aRH7_H95CwYWFTh0OM6xHPyaqRg7w8Ckm7gtvPwT0K4&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=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=SKg8kSam9WTOGGwC2yAwus0Nwm9IqZPy7LFetDXxRhs&s=QYzBHD5uA7H8e8q56uDUF25-W6AerO8i4DckVTYRCFg&e=