• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • An Alternative to Externally Described Printer Files, Take 2

    April 2, 2008 Ted Holt

    Note: The code accompanying this article is available for download here.

    Tomorrow, Lord willing, I will present a session entitled “An Alternative to Externally Described Printer Files” at the COMMON conference in Nashville. I’ll be sharing the report-building technique my reclusive colleague Cletus the Codeslinger introduced almost four years ago in this august publication. Since that time, various people have offered feedback, which Cletus and I have used to update the template that he provided. In this article, I present the updated template and two example programs: one using native I/O, one using SQL.

    First, if you haven’t read Cletus’ article, I encourage you to do so. While you’re at it, take a look at the example code.

    Now that we’re all up to speed, let me point out the enhancements that Cletus and I have made in response to your feedback.

    • The template includes stubs for both native input and SQL input. Look for comment lines with SQL and Native I/O in them.
    • There are several new printer settings.
         1. CreateBlankReport: If off, a spool file will not be generated if
             the input dataset is empty.
         2. PrintBlankLines: If off, blank lines will not be printed.
         3. PrintDetailsOnly: If on, only detail lines will be printed. That is, the
             report will not have headers and footers.
    • The PrintLine data structure defines one header line and two detail lines.
    • Error-handling is still not industrial strength, because Cletus thinks you should put your own standards in your copy of the template, but it is better than it was.

    You’ll notice that the code is all in fixed format. Both Cletus and I much prefer to work with free-format calculations, but we decided to publish fixed format in order to cater to as broad an audience as possible. To put it another way, we didn’t want people to think that this report technique applies only to free-format code. I used LPEX to convert the template to free-format.

    All feedback I have received to this report generation technique has been positive, although one frequent correspondent mentions that the other developers in his shop think this code’s a little funny.

    If you haven’t generated columnar reports using Cletus’ method, I hope you’ll give it a try and let me know what you think of it.

    RELATED STORY

    An Alternative to Externally Described Printer Files



                         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
    Maxava

    Migrating to a new IBM Power System?

    Whether it be Power8, Power9 or Power10 – Maxava has you covered

    Our migration service moves data from the old to the new server without disruption while the business continues to operate without impacting performance. Our service avoids long periods of downtime and means businesses can reduce the risk of moving to new hardware.

    To learn more about Maxava’s migration service, call us on 888 400 1541 or VISIT maxava.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    LANSA:  It's Time for 4 days of education at the LANSA User Conference, May 4 – 7, in Orlando
    Northeast User Groups:  18th Annual Conference, April 14-16, 2008, Sheraton Hotel, Framingham, MA
    Vision Solutions:  A Rewind Button for i5 Data? Read the Whitepaper

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    Getting Started with PHP for i5/OS: List Price, $59.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 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

    Xangati Launches End-User Network Troubleshooter It’s Official: Now We’re Power Systems and i for Business

    Leave a Reply Cancel reply

Volume 8, Number 13 -- April 2, 2008
THIS ISSUE SPONSORED BY:

WorksRight Software
Help/Systems
Guild Companies

Table of Contents

  • An Alternative to Externally Described Printer Files, Take 2
  • Performance Advice from a Mysterious Friend, Part 3
  • Admin Alert: How System i Boxes Impersonate Each Other, Part 2

Content archive

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

Recent Posts

  • POWERUp Brings IBM i Base Back Together in the Big Easy
  • New Nav for i Brings New Stuff to You
  • Why Infor’s IDF Is Important for Customer Innovation
  • Four Hundred Monitor, May 25
  • IBM i PTF Guide, Volume 24, Number 21
  • How Committed Is Big Blue To The IBM Cloud?
  • Immutable Copies Are Only As Good As Your Validation
  • Guru: IBM i *USRPRF Security
  • ERP Transitions Loom for SAP on IBM i Customers
  • Inflation Pumps Up Global IT Spending, Supply Chain Deflates It

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 © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.