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

Written 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?

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

Written 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.

• 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