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

January 18, 2012 | Volume 11 Issue 2


TOP STORY: Get the Day of the Week, Full Text Date Values, and More Within RPG Using SQL
FEATURED ARTICLE: The API Corner: Renaming and Moving Objects Doesn't Have to Be Difficult
NEWS HIGHLIGHT: RJS Enhances WebDocs to Include WebForms Integration and Improved email
FORUM: Zip/Unzip Now. Don't Wait for 7.1!
TRIAL SOFTWARE: Free Trial of Linoma's Managed File Transfer Software GoAnywhere
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates

Barcode400 Labeling Software makes it easy for IBM i users to design and print labels in minutes.

T.L. Ashford has over 28 years of experience in software development and backs that commitment with a highly qualified technical support team.

You can count on T.L. Ashford for your bar code, compliance and RFID labeling needs. Call 800-541-4893 to see what Barcode400 Software can do for you or use the Live Chat feature at


Feature Article - Programming
Get the Day of the Week, Full Text Date Values, and More Within RPG Using SQL

Create useful date-centric service programs with embedded SQL.

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


Sponsor - ASNA

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!


Feature Article - Programming
The API Corner: Renaming and Moving Objects Doesn't Have to Be Difficult

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

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


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor