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



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


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.