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
This Week @ the MC Press Bookstore

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