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

July 27, 2012 | Volume 9 Issue 30


TOP STORY: The CL Corner: Using Multiple Files with the RUNSQL CL Command
ADVERTORIAL: Partner TechTip: Automate the Un-Automatable
NEWS HIGHLIGHT: Hartzell Propeller Goes Paperless in Accounts Payable with Infor IntelliChief Document Management
MC STORE: Top 10 Best-Selling Titles
EVENT: SkyView: 5 Tips for Administering Security in the IFS
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
The CL Corner: Using Multiple Files with the RUNSQL CL Command

Take advantage of being able to join files with SQL.

bruce viningWritten by Bruce Vining

Last month, in "Run-Time Selection Using the RUNSQL CL Command," we saw how to build an SQL statement on the fly, selecting specific records/rows from the file/table SAMPLE. In this article, we'll look at how to combine information across files using the RUNSQL CL command. But before combining information, we first need to define that information, which will be accessed external to the file SAMPLE.


Advertorial - Help/Systems
Partner TechTip: Automate the Un-Automatable

Don't let operators or users waste valuable time and system resources by running reports and other processes with incorrect parameters or at the wrong time.

ChuckLosinski 116x116Written by Chuck Losinski

Do you still have people running reports repetitively at a certain time of day, week, or month? Maybe your ERP system has a series of demand reports, supplier order reports, or inventory reports that must be run, and you have an operator or clerk running those reports manually from a green-screen? Have these reports ever run with incorrect selection criteria? Maybe someone input an incorrect product line or date range? Or maybe someone took a vacation day and the reports didn't run at all?


Most Popular MC Press Books

Top 10 Best-Selling Titles


  1. IBM i Security Administration and Compliance
  2. Subfiles in Free-Format RPG
  3. System i Disaster Recovery Planning
  4. Control Language Programming for IBM i
  5. SQL for eServer i5 and iSeries
  6. Free-Format RPG IV
  7. Functions in Free-Format RPG IV
  8. The Modern RPG IV Language
  9. RPG Lover's Bundle
  10. HTML for the Business Developer


Don't Miss our Summer Sale--the Biggest Sale of the Year!


In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor






Search Sponsor