Re: Source code searching tool

Nobody seems to have mentioned the Arcad Observer tooling yet. (https://arcadsoftware.com/products/arcad-observer-application-analysis/)

Personally I would lean towards that over Pathfinder (who mysteriously still refer to the system as "iSeries" on their home page). Pathfinder admittedly have upped their game in recent years but there was a very long period of inactivity on the tool. There is also no expansion capability. That is to say that it only assists in understanding who-uses-what. These days most of us need that capability to begin with, but as the need to modernize the system grows we need tools to help move to the next level. To the best of my knowledge Pathfinder does not help in that area.

Arcad, on the other hand, have been continuously improving their tooling over the years and integrate well with RDi. Observer is part of a complete suite that includes modernization tools and full RDi integration. Well worth a look I think.

Similarly X-Analysis from Fresche (https://www.freschelegacy.com/en/data-sheets/x-analysis-complete-ibm-i-application-analysis-and-management-suite) is part of a full suite that can grow as your needs grow.

Both the Arcad and Freshe products have a lengthy pedigree and keep up with advances in the system.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Mar 2, 2017, at 7:20 AM, Bill Reed <breed@xxxxxxxxxxxxxx> wrote:

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

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