Pathfinder does support embedded SQL. I think it was several years ago they added it. So if I have the following in my RPG program:
------------------------------------------------------------------------------------------------------
EXEC SQL
Select CusName into :wkName from CusMs where CusCode = :peSelectCode;
------------------------------------------------------------------------------------------------------
then Pathfinder will show me this program as one which uses file CusMs as input, and also as one which uses fields CusName and CusCode should I want the usage of either of those fields. (It also now handles fully free-form RPG.)
What it doesn't handle (unless I've missed something) is SQL definition of files (as in the recent discussion of DDL vs DDS). It expects file specs to be in DDS source, and after changing source, I can ask it to rebuild the file(s) along with any dependent logicals, as well as recompile all using programs. If I were managing my files with other than DDS, I would have to do the file rebuilds some other way and then have Pathfinder just do the program compiles.
Bill Reed
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Wednesday, March 01, 2017 4:03 PM
To: Midrange Systems Technical Discussion
Subject: Re: Source code searching tool
A previous shop I was in two years ago had Pathfinder, and I found it lacking because it did not extract any field or file references from embedded SQL. I don't remember what release it was at, but I believe this shop kept all of their software up to date. I would love to be proven wrong because, in the past (before embedded SQL), I found this tool to be invaluable.
- Dan
On Wed, Mar 1, 2017 at 3:47 PM, Paul Nelson <nelsonp@xxxxxxxxxxxxx> wrote:
Pathfinder may be a solution:
http://hawkinfo.com/
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://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:
http://amzn.to/2dEadiD
midrange.com
