Create useful date-centric service programs with embedded SQL.

Written by Tom Snyder

Welcome to 2012! All of our year-end processes are complete, and it's the beginning of a new year with a clean slate. 2011 was a very clean year date-wise because it ended on a Saturday. Typically, there is always special handling with the last week of the year for one reason or the other, which makes working with data a prevalent topic. For this article, I wanted to share a few handy little SQL functions that I've put into service programs to extend the existing RPG date resources. And this is all done with very minimal code in a reliable way that is highly reusable.

ASNA Wings® is the fastest, easiest way to create a modern user interface for RPG programs. Wings transforms green-screen display files to modern browser pages. Because Wings uses IBM’s Rational Open Access RPG Edition, program logic and file IO remain on the System i. No big upfront design or analysis is required and Wings can be learned very quickly. Unlike screen scrapers, all of the display file data is presented to Wings, so there are many ways to further customize the presentation layer.

Don't miss our Free One-day Training: Open Access RPG & Wings. Ft. Lauderdale - Feb 9th or Las Vegas - Feb 24th. Register Today!

The Rename Object API offers flexibility above and beyond just renaming.

Written by Bruce Vining

In last month's article, Deleting Objects, we reviewed a rather general-purpose API: Delete Object (QLIDLTO). This month, we'll look at another general purpose API: the Rename Object (QLIRNMO) API, which is documented here and has been available since V2R3. The Rename Object API, as you might expect, allows you to rename an object. Not as obvious, the QLIRNMO API also allows you to move an object. As with QLIDLTO, using the Rename Object API allows you to directly operate on an object without having to run a CL command from your RPG application program under the covers.