Volume 7, Number 44 -- November 27, 2007

EPI Updates DB2/400 Database Assistant to Track CL

Published: November 27, 2007

by 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.


EPI Now Distributing CenturioDB Tool

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

Sponsored By

For tough production and warehouse environments,
Affirmative introduces the industrial-strength YEStablet wireless thin client.

Featuring a magnesium alloy case and shock protection boot
for industrial applications, the new YEStablet supports 5250 and 3270 emulation
with built-in GUI and touch-screen keyboard.

The USB port supports barcode scanners and other data collection devices.
Vehicle mount and wearable options are also available.

Visit www.affirmative.net for more information.

Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

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

The Four Hundred
Redefining Security the New Goal of Former i5/OS Security Architect

The System i Fourth Quarter Sales Strategy

Power Systems Division Eyes Cognos Deal; Business Systems Shrugs

As I See It: The Sick Guys in Your Wallet

The Linux Beacon
Red Hat to Use Automation, Virtualization to Eat the Server Space

Red Hat Puts Out Fedora 8 Rev of Development Linux

Intel Announces First "Penryn" Xeon Processors

Mad Dog 21/21: Symphony for the Devil

Big Iron
IBM Acquires BI Software Specialist Cognos for $5 Billion

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

Four Hundred Guru

Odds and Ends

Admin Alert: How Big is My IFS?

System i PTF Guide
November 24, 2007: Volume 9, Number 46

November 17, 2007: Volume 9, Number 45

November 10, 2007: Volume 9, Number 45

November 3, 2007: Volume 9, Number 44

October 27, 2007: Volume 9, Number 43

October 20, 2007: Volume 9, Number 42

The Windows Observer
Windows Server 2008 Pricing and Packaging Set by Microsoft

'Viridian' Hypervisor Gains Formal Name: Hyper-V

Intel Announces First "Penryn" Xeon Processors

Microsoft Makes Gains in HPC Market

The Unix Guardian
Solaris Conversion Rate: Sun Sheds Some Light

Blade Servers Make It to the Top HPC Sites

Intel Announces First "Penryn" Xeon Processors

The Blue Cloud Is IBM's Commercial Cloud Computing

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar


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

Printer Friendly Version

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

News Briefs and Product Shorts:

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 . . .

Four Hundred Stuff


Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement