Midrange News for the IBM i Community

Posted by: GL Slone
Impact Analysis Tools
has no ratings.
Published: 08 Jan 2015
Revised: 19 Jan 2015 - 2555 days ago
Last viewed on: 16 Jan 2022 (5226 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Impact Analysis Tools Published by: GL Slone on 08 Jan 2015 view comments(6)

We are in the process of looking for, and purchasing, impact analysis tools for our iSeries - V7r1. We have no tools to tell us where fields, files, etc are being used within our applicatons. I used Hawkeye Pathfinder in a different life, but i cant find out how up-to-date they are?

What are some of the others that you all are aware of? Bob, does your toolboxes have anything like that?

As part of the tool, we want to be able to use it on RPG400, Free, Embedded SQL, .NET apps hitting the i, stored procedures, etc.



Return to midrangenews.com home page.
Sort Ascend | Descend


(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Comment on: Impact Analysis Tools
Posted: 7 years 9 days 19 hours 2 minutes ago

Probe/Abstract from ASC was usually better tha Hawkeye, but they were purchsed by HelpSystems a while back and I have no idea if they still over Abstract.

Hawkeye is usually on maintenance-mode only--not sure they update it much, but you could call them to find out.

I built a "Field Where Used" for IBM in the pre-Y2K Era that found where all fields and files were being used, but that was 400 code only and I don't even know if they still offer it--I would assume not.

So to me, Google and/or look at Abstract.

Posted by: Viking
Premium member *
Comment on: Impact Analysis Tools
Posted: 7 years 9 days 18 hours 42 minutes ago

Yes, Help Systems offers it:  http://www.helpsystems.com/abstract

I used it at my last place and liked it.

Posted by: Midnite1
Premium member *
Comment on: Impact Analysis Tools
Posted: 7 years 9 days 3 hours 46 minutes ago

Thanks for responding.

I talked to HelpSystems yesterday about Abstract. They seem to be updating regularly. She is sending me more info.

Looks like from what i have gotten from Hawkeye, Bob you are dead on it. They donot seem to be doing any more development, which means it probably dont do plugins, etc.

Viking, was Abstract able to track fields/files used in embedded SQL and subprocedures, especially those created on a SQL server like .NET?

i will continue to do my research/googling today and give my recommendation.

Posted by: Viking
Premium member *
Comment on: Impact Analysis Tools
Posted: 7 years 9 days 1 hours 10 minutes ago

As I recall, the last time I worked on it (a few years ago) they were working on an update to be able to keep track of usage within embedded SQL, etc.  That was important to me since we had a lot of embedded SQL, so that was lacking at that time.  However, we never had .NET or the need to use it on any SQL Server database so I don't know that answer.

Posted by: starbuck5250
Premium member *
Comment on: Impact Analysis Tools
Posted: 7 years 9 days 39 minutes ago

We use Total/400 and are mostly happy with it (who is ever completely happy with software?)

It does handle fully free RPG and SQL.

It does get regular updates.

The developer is very attentive when it comes to support.

No RDi plugin.

I don't understand how any cross reference tool is going to know about a .NET app that reaches in through ODBC.

Posted by: SteveCCNJ
Premium member *
Egg Harbor Twp., NJ
Comment on: Impact Analysis Tools
Posted: 6 years 11 months 29 days 23 hours 3 minutes ago

There is also X-Analysis from Databorough (just acquired by Fresche Legacy)  I don't know anything about it other than that it exists and is pushed somewhat by IBM.  IBM had them do a Redbook on modernization using their tool: 


It appears to be much more than just a "where used" tool, but it does include that.