Increase productivity and reduce costs with the
Database Assistant for the System i and iSeries.

       If the question is how can I speed up the maintenance cycle and get application changes into production quicker, the Database Assistant can provide the solution. It can reduce typical database and RPG application maintenance projects by up to 80%.

       Programmer's know the most time consuming part of any change project which involves modifying fields in the database is: First, manually locating and adjusting all occurrences of any changed fields and related fields in the associated database physical and logical files. This involves both finding and changing the field specifications in impacted DDS source members and then manually recreating the related data files. Second, manually writing data conversion programs to convert the file data. Third, and even more time intensive, visually tracking all impacted field references in the corresponding program source code and then manually updating any impacted internal record layouts and data structure definitions in the RPG source members and recompiling the programs.
 

        The Database Assistant frees up valuable programming time by drastically reducing the manual programming effort required to effect most DB2/400 field changes on the iSeries and AS/400. It's ideal for field expansion projects and adding new fields to the database.

Functional Description. 

• Locates all field relations in the database from the selection of a single field or fields in an individual database, display or printer file.
• Works with both externally defined and program described RPG/400 and RPG IV (ILE) record layouts and passed parameter lists.
• Makes it easy to track and identify field changes and impacted field relationships in DB2/400 database physical and logical files, RPG source programs and display and printer file source members..
• Automatically updates PF and LF DDS source members and RPG source programs with required field changes.
• Rebuilds files.
• Converts data.
• Globally recompiles RPG programs, display and printer files.
• Provides impact analysis reporting.
• Intuitive easy to use PDM style user interface.
• Ideal for field expansion projects or adding new fields to database files.

In a Nutshell. 

      Unlike other more expensive change and analysis solutions which generate as much work as they save and require a major learning curve the Database Assistant is designed to be easy to use and is much more intuitive to work with. Programmer's will resort to it time and time again to speed up maintenance projects and get the job done.