• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • New Software Provides CL With Direct Database Access

    September 15, 2009 Dan Burger

    Old habits may die hard, but here’s one (or more) that will pass with few tears being shed or remorse being noted. IBM i programmers in the CL camp take note. All the time consuming grunt work you put into gaining access to database information using RPG, COBOL, or C user interfaces are no longer necessary. A new product called CL for Files (CLF) not only provides direct database access for CL commands, but also support for accessing both display files and print files.

    That clacking sound you hear are shackles being released.

    Bruce Vining–an ex-IBMer with enough OS/400 (i OS) knowledge to fill a Rochester, Minnesota, warehouse–is the mind behind CL for Files. His company, Bruce Vining Services, introduced the first in a series of products to be marketed under the PowerCL name.

    In short, CL for Files is a productivity toolset for IBM i developers, operators, systems administrators and QA professionals. Many of you old pros have learned to work around the short-comings of CL using other languages to assist CL commands. Not only will CLF help you wizened old veterans, but it will also be a boon for CL developers with no knowledge of RPG, COBOL or C–those on a mission to create efficient system maintenance utilities, application control programs and test scripts without support from other developers.

    Programmers and developers have accepted (not all of them quietly) using two languages and multiple programs to pass information back and forth between the programs for more years than it takes hair to turn gray and beards to grow long.

    “It’s not what I consider to be highly productive; not a good use of programming talent,” Vining says. “Most people with highly skilled development staff or programmers would much rather be solving business problems than working around language limitations.”

    Vining took the biggest limitations with CL and hurdled them. He began with the limited random access to database information and moved on to the inability of CL to create reports. Because CL could not write to a file, it, therefore, couldn’t write to a report.

    CL for Files provides all the support that is found in RPG, COBOL, and C, plus a few things that are not in any of those languages, and made them directly accessible as commands in a CL program.

    In the AS/400 world, you’ll find a great number of people familiar with CL. Not all are programmers, but whether you have programming skills or not, CLF provides the capability to work with database files, interactive display files, and printer files directly from CL.

    The key to the CL highway is its pre-compiler. By way of comparison, it is similar to the pre-compiler used in RPG, COBOL, and C to access SQL. The similarity is that it automatically generates instructions that eliminate the need for programmers to do those types of operations. In other words, it makes programmers more productive.

    CLF is compatible with i5/OS V5R4 and i 6.1 (V6R1). Vining says the product makes use of many of the CL enhancements IBM introduced in OS/400 V5R1, noting that the product could not be as efficient operating on earlier releases of the OS. Most importantly, the pre-compiler became much more feasible.

    (As a side note, at a recent Wisconsin Midrange Computer Professional Association user group meeting where Vining was the guest speaker, he took a hand count of those using V5R3 are newer versions of the OS and everyone in attendance [approximately 30] were up to date to that extent. The majority was on V5R4 and a good number were on 6.1, Vining said. User groups clearly represent a more active individual and more progressive AS/400 shops, but it’s an indicator of the system requirements of active programming professionals.)

    This is the first general use product from Bruce Vining Services, but the company has been involved with designing tools on a custom programming basis and Vining has a long list of design and control products that were accomplished during his 28-year career at IBM when he was heavily involved in the operating system most know as OS/400, but currently marketed as i OS.

    Vining says there will be more products in the Power CL pipeline. “Power CL is the family name and CLF is the first product in that family,” he says. Additional products are under development at this time.

    The price of CL for Files, which is available now, is $3,495 per server or LPAR. It includes unlimited use of the CLF pre-compiler, generation tools, sample programs, free run-time support, and a six month maintenance contract.

    “We asked people at companies involved in the testing of the product what they thought it was worth and then we priced it significantly lower than that,” Vining says.

    The base CLF option and the runtime support is no charge. That allows any CLF program developed on an LPAR or a server with the pre-compiler installed (the $3,495 fee) to be moved to any machine that has the no charge base option and it will run. Development using just the base runtime support can result in full-functional applications without using the pre-compiler, however, productivity gains provided by the pre-compiler are lost and coding by hand using conventional editors would be required.

    Vining says part of this reasoning takes high availability into account. “We did not want those with a hot backup site finding they did not have a license for the runtime to run the program. That’s why we made the runtime free.”

    In multi-server of multi-LPAR systems, the only servers using the pre-compiler–the servers used by the programmers and developers–would require a license fee. For more information, check out the company’s Web site at www.brucevining.com.

    RELATED STORY

    V5R4 CL Enhancements, Revealed and Detailed



                         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
    ARCAD Software

    Embrace VS Code for IBM i Development

    The IBM i development landscape is evolving with modern tools that enhance efficiency and collaboration. Ready to make the move to VS Code for IBM i?

    Join us for this webinar where we’ll showcase how VS Code can serve as a powerful editor for native IBM i code and explore the essential extensions that make it possible.

    In this session, you’ll discover:

    • How ARCAD’s integration with VS Code provides deep metadata insights, allowing developers to assess the impact of their changes upfront.
    • The role of Git in enabling seamless collaboration between developers using tools like SEU, RDi, and VS Code.
    • Powerful extensions for code quality, security, impact analysis, smart build, and automated RPG conversion to Free Form.
    • How non-IBM i developers can now contribute to IBM i projects without prior knowledge of its specifics, while ensuring full control over their changes.

    The future of IBM i development is here. Let ARCAD be your guide!

    Watch Now

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Manta Technologies:  Fall Sale on i training courses! Order by October 15 and SAVE 25%
    BCD:  Webinar, Sept. 23 - Rapidly Web Enable your IBM i 5250 Applications in a Cost Conscious Market
    COMMON:  Celebrate our 50th anniversary at annual conference, May 2 - 6, 2010, in Orlando

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    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 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
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    Greater Responsibility a Necessary Part of Vlok’s Vision FROG: PC-based SQL for DB2 for i

    Leave a Reply Cancel reply

Volume 9, Number 33 -- September 15, 2009
THIS ISSUE SPONSORED BY:

Help/Systems
LANSA
Profound Logic Software
Patrick Townsend Security Solutions
RJS Software Systems

Table of Contents

  • IBM Targets Mid Market with Cognos Express
  • Free RPG Editor is Open Source, Runs on Linux
  • New Software Provides CL With Direct Database Access
  • Profound Gives a Speed Boost to 5250 Screen Converter
  • i OS Twitter Utility from Kisco Gets More Useful
  • Transoft to Use ASNA’s System i Modernization Tools
  • New i OS Security Firm to Offer Multiple Wares, Services
  • ACOM Re-engineers Workflow in EZContent Manager, Hires Channel Master
  • Robot/CONSOLE Manages Logs for Multi i Machines
  • Symtrax Updates Archive with Security and Search Improvements

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