MAGAZINES

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

ISSUE HIGHLIGHTS

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 www.tlashford.com


Read More >>

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.


Read More >>

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?


Read More >>

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!


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

Forums Sponsor

POPULAR FORUMS

 

Forums

 

 

Search Sponsor

 

POPULAR SEARCHES

 

Search

 

 


Read More >>
   MC-STORE.COM