Kisco Information Systems (www.kisco.com) announced the availability of a new software product for the IBM iSeries and AS/400 platform. The utility, called QRYTool/400, helps manage environments that have come to heavily rely on adhoc Query/400 reports.
Since its introduction in 1988, the iSeries (originally AS/400) has included an excellent adhoc reporting tool called Query/400. Using any iSeries database, reports and query displays can be easily and quickly created. Many installations have even implemented Query/400 reports and displays into their production environment.
The problem arises when it comes time to make changes to the database. Then you have to remember which queries on your system use the changed database and then update each one so that it will not fail the next time the query is run. If you have only a small handful of queries, this is not a problem; but if you have more than just a few, it can be quite a task identifying the queries that need to be "recompiled".
Using QRYTool/400, you can analyze the queries that are defined in a specific library (or in all libraries) and then review the queries that use any specific file object. This will let you quickly identify the queries that need to be changed.
The review process is a two-step process. The first part extracts information from your system about existing query definitions. Then, the second part either displays this information or lists the information on a report. You can choose to analyze the queries from a single library or from all libraries on your system. When using the on-line review option, you can even switch over to update your queries and you can also select queries to run.
QRYTool/400 features include the following:
- Run quickly for a single library
- Run globally for all libraries
- On-line review of analysis results
- Available printed reports for archive storage
- Work with queries from on-line display
- On-line display by Query or by Filename
- Easy to install and use
Additional information on QRYTool/400 can be found at www.kisco.com/qrytool.
QRYTool/400 lists for $395.00 US. Kisco Information Systems offers a free 30-day evaluation of the product that can be downloaded with complete software documentation in PDF format from www.kisco.com. To obtain a free evaluation on CD call Kisco at (518) 897-5002 or e-mail email@example.com.
For details, contact:
Rich Loeber, president
7 Church St.
Saranac Lake, NY 12983
Fax: (518) 897-5003