One of my favorite programming techniques is linking together functionality to make even-more-powerful functionality. An example of this is wrapping an SQL user-defined table function (UDTF) around a System i list API to retrieve a given list through an SQL interface. As an example, let's explore a service program that can be used for exactly that purpose.
NEW BOOK:Subfiles in Free-Format RPG. The ability to master subfiles can define a programmer’s career. Over a decade in the making, author Kevin Vandever has completely reworked and updated his best-selling subfiles classic to make use of the latest free-format programming style. It is the ultimate guide to subfiles and one that every programmer working with IBM Power Systems will find indispensible. Click now for a FREE chapter and to learn more. >> Read More >>
SpoolFlex's ability to convert spool files into native Excel spreadsheet format with predictable results impresses even the most seasoned IT pros.
Written by Chris Smith
SpoolFlex from DRV Technologies is a tool for converting and distributing reports, or spool files, that makes children's play out of formatting report data into Excel. Unlike outputting to a comma-delimited file, when a report is converted directly into Excel's XLS format, report headers are in the right place, lines break where they are supposed to, and output retains the crisp formatting that was always intended.
The Remote System Explorer (RSE) is the most widely used tool within Rational Developer for System i and WebSphere Development Studio Client (WDSC). Focused exclusively on the RSE within Rational Developer for System i and WDSC, this book covers topics such as getting started, installation, understanding the Workbench, managing your i5/OS objects and members, editing, compiling, debugging, and much, much more. Click now to receive a FREE chapter of this best-selling developer resource! >> Read More >>
Written by Mike Faust
Written by Chris Smith