MDXREF is a powerful, time-saving tool that tracks and reports on the inter-relationship of all files and objects in application libraries on an IBM AS/400. This is an important cross-referencing tool for a company if ongoing modifications are being done or if the company is responsible for issues found in an application.

MDXREF takes less than 1 hour to install/re-install and comes with a very easy-to-use set of interactive programs to provide the answers for whatever type of cross-referencing information the user is looking for. The information may also be printed to a report or viewed electronically. Also, if purchasing MDCMS with MDXREF, application changes are automatically captured for the MDXREF database and all related objects may be requested for modification at once.

File Referencing

• all fields defined for a file
• the sort sequence of a file
• the data contained in the file
• logical file indexes over a physical data file
• automated file overrides or copies to other files
• display/printer file field references to other files
• all programs that use a file and how the file is used
• all queries using a file
• CL programs using files with FMTDTA or OPNQRYF commands

Process Flow

• all programs calling a program, command, or query
• all commands invoking a program
• all menues calling a program, command, or query
• reporting facility to show the entire process flow of an application as well as all files used by the process flow

Comparison functions

• compare libraries to check for missing or duplicate objects within or across applications
• compare objects to check for differences
• compare file formats
• compare the actual data stored in files

Journal Analysis

• view all updates to data in a customizable, easy-to-read format
• filter the updates by user, program, date, or field values

Other Highlights of MDXREF for the IBM iSeries system

• automatically identifies all database and program references system-wide
• allows for logical subsets of cross-reference information by application
• supports ALL AS/400 programming languages
• All information may be displayed or printed. Many reports may also be electronically exported in text or Microsoft Excel format.
• very easy to use
• can be used to greatly assist in all other application changes