MC Press Resource Centers
MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power

August 17, 2011 | Volume 10 Issue 16


TOP STORY: Don't Be Misled by SETLL *LOVAL
FEATURED ARTICLE: The API Corner: Determining the Last Spool File Created
NEWS HIGHLIGHT: Healthcare Providers Boosting IT Staff Ranks
FORUM: How to Reprint a Subset of Labels in an OUTQ
BUYER'S GUIDE: SpoolFlex Electronic Report Conversion, Distribution and Archiving
Manage Subscription | Contact Us

Sponsor - CNX Corporation

Dazzle your IBM i users!

Valence combines state-of-the-art browser components with your favorite business language (RPG) to produce World Class Web 2.0 apps on IBM i.

Learn industry-standard techniques for developing true Web 2.0 applications with popular UI features such as grids, forms, trees, charts, graphs and much, much more!

Now available: Valence Version 3.0 - includes mobile device support, the Valence Nitro integrated source editor and numerous other features. Download the Community Developer Edition for free!


Feature Article - Programming
Don't Be Misled by SETLL *LOVAL

Be careful when using SETLL *LOVAL on keyed access paths containing numeric key fields.

junlei_liWritten by Junlei Li

Almost every RPG programmer has become accustomed to setting the file pointer to the starting position of a logical file by specifying the SETLL (Set Lower Limit) RPG operation code with figurative constant *LOVAL as the search argument operand, or similarly, setting the file pointer to the end of a logical file by specifying SETGT (Set Greater Than) with *HIVAL. The SETLL *LOVAL technique worked perfectly for decades, doing exactly what we RPG programmers expected. But is it always to be trusted everywhere?


Feature Article - Programming
The API Corner: Determining the Last Spool File Created

The QSPRILSP API can simplify your access to a job's most recent spool file.

bruce_viningWritten by Bruce Vining

Last month, in "Just How Many Spool Files Do You Have?," we looked at the Retrieve Spool Information API QSPSPLI. I received quite a bit of feedback on the article—some suggesting a follow-on topic, others reporting a problem they were running into.


MC Showcase Buyer's Guide - Featured Product
SpoolFlex report conversion and distribution software automatically converts IBM i, iSeries and AS/400 reports to electronic formats and puts those reports into users hands instantly.


  • Convert spool files to as PDF, CSV, RTF, HTML, TXT, XML, or Excel Spreadsheets
  • Deliver reports with automated e-mailing directly from your IBM System to the people who need them, without additional hardware
  • Archive copies to your network; search, view and re-send original reports without having to re-run them again!
  • Intelligently sort, split, and combine reports based on variable data on the spooled page, dynamically naming and routing to multiple users
  • All native RPG software, SpoolFlex requires no additional hardware or custom programming
  • 100% Native IBM i Solution Compatible with Current IBM Operating Systems

SpoolFlex automates report distribution, getting data where it’s needed in the blink of an eye, without breaking the bank. For a closer look at SpoolFlex, view one of our online recordings, schedule an online demonstration, or request a free trial


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor