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.
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.
thanks
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.
Yes, Help Systems offers it: http://www.helpsystems.com/abstract
I used it at my last place and liked it.
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.
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.
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.
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:
http://www.databorough.com/IBMi-as400-iseries-redbook-maintenance-modernization-x-analysis.html
It appears to be much more than just a "where used" tool, but it does include that.