• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • EPI Updates DB2/400 Database Assistant to Track CL

    November 27, 2007 Alex Woodie

    Excel Program Inventions recently launched Database Assistant version 2.2, a new release of its field-level change and impact analysis tool designed for speeding database maintenance projects for RPG applications. With the new release, the tool gains the capability to track changes made to CL, and to generate SQL for any changed files.

    From time to time, programmers run into situations where they need to expand the fields in their applications, or add entirely new fields to support the growth of the company or compliance initiatives. In these situations, it’s advisable to use some type of tool to automate as much of the work as possible.

    One such tool that could come in handy is the Database Assistant, sold by EPI of Long Beach, California. According to EPI, Database Assistant helps by manually locating and adjusting all occurrences of changed fields and related fields in database physical and logical files, including finding and changing field specification in impacted DDS, and then manually recreating the related data files.

    In addition, the software performs data conversion, tracks all references to the impacted fields in the source code, updates any impacted internal record layouts and data structure definitions, and then recompiles the program when it’s done. And all of this is performed automatically. “It really does automate and accomplish a fantastic amount of otherwise manual programming work for the user,” says John Caine of EPI.

    With version 2.2, the tool now includes support for CL to track and pinpoint changes to CL programs, in addition to RPG applications. The software will also generate SQL for changed files, although this function requires Query/400 or its successor product, DB2 Web Query, to be loaded on the machine. However, the product functions perfectly fine on regular DDS, if Query/400 or DB2 Web Query are not used.

    Database Assistant version 2.2 is available now, and supports OS/400 V4R5 and higher. Pricing is tier based and ranges from $2,350 to $4,550. For more information, visit www.epi-software.com.

    RELATED STORY

    EPI Now Distributing CenturioDB Tool



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Rocket Software

    Two Steps Forward, No Steps Back

    For over 35 years, Rocket Software’s solutions have empowered businesses to modernize their infrastructure, unlock data value, and drive transformation – all while ensuring modernization without disruption.

    LEARN MORE

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    RJS Software Systems:  Make your office paperless with WebDocs
    COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    LANSA:  Hear how System i shops achieved modernization with RAMP

    IT Jungle Store Top Book Picks

    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket Developers' Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    Lawson and IBM Target Retailers and Manufacturers in Germany System i Developers and .NET 2.0, Part 2: Web Development Using ASP.NET AJAX

    Leave a Reply Cancel reply

Volume 7, Number 44 -- November 27, 2007
THIS ISSUE SPONSORED BY:

New Generation Software
Vision Solutions
Profound Logic Software
ARCAD Software
Affirmative Computer

Table of Contents

  • NetManage Fixes Printing, Performance Issues in Web-Based Emulation
  • Verastream Streamlines Host Access for Hospital Billing Specialist
  • Help/Systems Extends Robot to Linux Servers
  • VAI Gives Retailers a Windows Option for Backup
  • Lawson S3 Is Already 64-Bit on i5/OS, Like All System i Apps
  • MPG’s PerfNav Gains New Summary Report
  • CYBRA Gives Users More Control Over System i Printing with MarkMagic 6.1
  • EPI Updates DB2/400 Database Assistant to Track CL
  • Teamstudio Supports Notes/Domino 8
  • AMR Predicts Moderate ERP Spending Growth for 2008

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle