• 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
    COMMON

    We Are Stronger Together!

    On behalf of the IBM i community, thank you to our valued COMMON members. We recognize and understand the challenges our members have faced this year, and we have faced many of the same challenges. As always, we are committed to our members and this community, and are working tirelessly on your behalf. Showing our commitment, we have decided not to increase dues for 2021. Through these unprecedented times, our top priorities remain serving the membership, providing benefits to support your career, and being the voice of our members and the industry.

    It’s Time to Renew

    Now more than ever, COMMON is essential to the IBM i community. We respectfully ask for your continued support by renewing your membership.

    Your continued commitment to COMMON enables us to:

    • Develop valuable in-person and on-demand education
    • Connect you with peers, industry experts, and vendor partners
    • Boost the visibility of your business as an IBM i leader and help you stay informed about the opportunities ahead
    • Reinforce the value of IBM i through educational programs, events, and services
    • Spotlight issues and gain visibility for the IBM i community
    • Provide timely communications about issues that impact our members
    • Provide resources such as online job postings, an expanded web presence through the membership directory, and digital advertising opportunities

    COMMON is strong because of YOU. Together, we will tackle these challenges, no matter what the future may bring, and ensure not only that the IBM i community will get through this, but will thrive.

    Renew Your Membership Now

    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

  • Taking The Full Measure Of Power Servers
  • It’s Time For An Application Healthcheck
  • Guru: What’s Your RDi Preference?
  • As I See It: How Did Cyber Security Get So Bad?
  • Here Are the New IBM i Champions for Power
  • 2021 Predictions for IBM i: Part Two
  • Zend Server for IBM i Now 64-Bit, Available Via RPM
  • New IBM i Logo, Publication
  • Four Hundred Monitor, January 20
  • IBM i PTF Guide, Volume 23, Number 3

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