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

August 20, 2014 | Volume 13 Issue 15


TOP STORY: Import CSV Files with File Correcting
FEATURED ARTICLE: The API Corner: Getting Directions Using Inquiry Messages
NEWS HIGHLIGHT: Alliance Key Manager Now Available on AWS Marketplace
WHITE PAPER: Checklists for Checklists on Checklists … Why Not Automate?
MC INDUSTRY BLOGS: 3 Trends Changing Expectations Inside IBM i
MC VIDEO PORTAL: Step by Step Approach to Implementing Object Level Security
EVENT: Five Top Problems Solved By Automated Report Delivery

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 30 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. Watch our video to see what Barcode400 Software can do for you. Call 800-541-4893 or use the Live Chat feature at


Feature Article - Programming
Import CSV Files with File Correcting

Build your own user-friendly CSV file-upload programs.

rafael victoria preiraWritten by Rafael Victoria-Pereira

Editor's note: This article is an excerpt from the new MC Press book Flexible Input, Dazzling Output with IBM i.


This chapter presents a user-friendly CSV file upload program. While the program itself is simple, it uses some interesting procedures to recover records with the most common user errors in the CSV file. In


Sponsor - ASNA

ASNA Mobile RPG (MR) empowers RPG programmers to create IBM i smartphone and tablet apps with ILE RPG. MR doesn’t requiring learning HTML or JavaScript or PHP or any other of the traditional mobile development technologies. Rather, RPG programmers simply use plain ol’ RPG to create smartphone and tablet apps. A Windows-based mobile UI designer is included that features many mobile “widgets” (including maps, charts, signature capture, images and others) for creating the mobile user interface. Learn more today!


Feature Article - Programming
The API Corner: Getting Directions Using Inquiry Messages

Use APIs to send and receive messages.

bruce viningWritten by Bruce Vining

Last month, in Trying to Allocate an Object?, we enhanced the program AllocObj, which was first introduced in Problems Allocating an Object?. The enhancement was that the program, if run in an interactive job, would build a subfile listing those jobs with locks on the object. From this list, the user could decide to contact someone about one or more of these jobs, end one of more of these jobs, and/or cancel the current running of AllocObj.


This month, we are going to look at the batch side of AllocObj.


Sponsor - The MC Press Bookstore

The IBM i no longer stands alone. It now lives harmoniously with its other server brethren. Flexible Input, Dazzling Output with IBM i shows you how to build the interfaces you need to move data between servers. The free, open-source code and tools included with the book allow you to import and export data, automate data transfers, create attractive charts and graphs easily, generate top-notch Excel spreadsheets, and much more. And it's all done with the language you know and love: RPG. Pre-order yours today!


Give your IBM i the freedom to connect to the rest of the world.


MC Video Portal

MC Video Portal

Step by Step Approach to Implementing Object Level Security

In this Webinar:  More organizations are realizing the need for implementing object level security -- especially for database files that contain information which must comply with various laws or regulations. But the question many administrators have is, how do you secure files without breaking the application or other processes? During this presentation, security expert Carol Woodbury will discuss how. Configuration options, testing steps, "gotchas" to avoid, along with real-life examples will be presented.


In the News

The Latest from IBM

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor