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

May 20, 2015 | Volume 14 Issue 10


TOP STORY: What's Wrong with the RPG World?
FEATURED ARTICLE: The API Corner: What's the Status of My Data Queue?
NEWS HIGHLIGHT: ProData Announces New Release SQL/Pro 5.0
TRIAL SOFTWARE:Easiest Way to Save Money? Stop Printing IBM i Reports 
EVENT: The Importance of VIOS and How to Achieve Watertight Integrated Monitoring
BMC VIDEO PORTAL: Introduction to Configuring iAccess Servers to use SSL

Sponsor - Profound Logic Software

Try Profound UI FREE for 30-Days!

Break free from green screens for rich, modern desktop & mobile apps

Don’t let old-fashioned 5250 screens hold your business back! Modern web and mobile GUIs have been proven to:

  • Make users more efficient and agile
  • Reduce training costs
  • Extend the life of your IBM i applications

Profound UI lets you use your own RPG code & development talent to produce REAL modern interfaces (not just screen scraping). No Java, NET, or middleware needed!


Download your free trial of Profound UI


Feature Article - Programming
What's Wrong with the RPG World?

Do you ever kind of get sick of the way RPG is kicked around? I do too, but I guess in this article I'll do some of the kicking because, in some ways, it's our own fault.

david shireyWritten by David Shirey

Maybe it's the weather. It's really hot today, hot and muggy, and last week it was so cold I was back to wearing sweatshirts. So I'm not prepared for this hot weather, and it always takes me a bit of time to adjust. And what do I do when I'm in the slow process of adjusting? I get cranky.


Sponsor - New Generation Software, Inc.

Free, Live Webinar: TODAY at 11AM PDT. Does this sound familiar? Reports based on yesterday’s data? Queries you have to change every time they run? Programs generating spool files no one has time to read? Analysts storing sensitive data in Microsoft Excel and Access? Users rejecting Query/400? Programmers writing new queries instead of new applications? Attend this webinar and learn how you can extend and enhance data access without sacrificing control or your budget. Call 800 824-1220 or register at


Feature Article - Programming
The API Corner: What's the Status of My Data Queue?

Find out by using the Retrieve Data Queue APIs.

bruce viningWritten by Bruce Vining

In the past month or so, I've received two requests related to accessing data queue (*DTAQ) information. The first request concerned finding out how many messages were currently on a *DTAQ and how long the oldest message had been on the queue. These questions, to me anyway, suggest a management application to periodically poll *DTAQs and determine whether they are backlogged and in need of additional readers to be started and/or are stuck for some reason, for instance an outstanding inquiry message.


Sponsor - The MC Press Bookstore

Have you heard? RPG is now fully free-format! This latest edition from RPG expert Jim Martin is your one-stop resource for free-format information. It’s a must-read for all RPG programmers, featuring completely updated code. See the new H, F, D and P specs in action in this easy-to-use reference guide. You’ll learn rules and syntax but also grasp how this modern style of coding can improve your overall productivity--from initial development through maintenance. Get your copy today!


MC Software Center

Auditing Tool with Built-in Reports for SOX, PCI Compliance

PowerTech Compliance Monitor simplifies the task of audit reporting. It comes with a set of reports for SOX, PCI, and even MICS gaming standards.

IBM i's audit journal is often so large and cryptic, that most IT staff struggle to review the logged activity.
Compliance Monitor analyzes your audit data across multiple systems and displays the exceptions to policy with remediation tips—all from your web browser! You can generate reports as PDF or Excel files.

Need custom reporting? Compliance Monitor’s flexible filters allow you to generate reports on any audit data you need—from system configuration to user activity.

Streamline your audit reports. Try Compliance Monitor free for 30 days.



The following trial software can also be found at the MC Press Software Center.


ACO MONITOR manages your IBM i 24-hours a day and notifies you immediately when your IBM i needs assistance!  

Auditing Tool with Built-in Reports for SOX, PCI Compliance 

Backup and Recovery on IBM i: Your Strategy for the Unexpected 

Control and Monitor User Access from Desktop PCs (ODBC, FTP)

Easiest Way to Save Money? Stop Printing IBM i Reports 

Electronic Forms: Free Trial Software – No Obligation

Free Trial of INPRO's TimeZoNe/400 (TimeZoNe Simulation Utility)

Free Trial of Linoma's Field and Backup Encryption Software Crypto Complete

Free Trial of Linoma's Managed File Transfer Software GoAnywhere

Hassle-Free IBM i Operations around the Clock 

Manage IBM i Messages by Exception with Robot

Query, Reporting & Analytics for IBM i: Free Trial 

Real-Time Message Monitoring and Notification for IBM i

Real-Time Performance Monitoring and Reporting for IBM i

Report Distribution: Free Trial Software – No Obligation

Try the Most Powerful Anti-Virus Protection for IBM i for Free! 

Try the one package that solves all your document design and printing challenges on all your platforms

*ALLOBJ and not afraid to use it? Privileged user management is here

*MS Office Connector for Query/400...FREE Trial!


The MC Resource Centers bring you the widest selection of white papers, software, webcasts and more for you to choose from and at MC Press we’re all about choice. We’re even giving one lucky person the opportunity to choose their own prize in our “It’s All About Choice” contest for a $250 Best Buy gift card.  Visit the MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security,  and MC Disaster Recovery Centers today and select as many of the FREE offerings you would like to receive. While there, enter the contest and you may just win a $250 Best Buy gift card


Have Trial Software you would like to list? Click here or call (208) 726-6822 for information.



In the News

Vendors:  Have a press release to share?  Send it to MC Press.

The Latest from IBM

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor



MC Video Portal

MC Video Portal

Introduction to Configuring iAccess Servers to use SSL

Due to popular demand, Carol has updated her presentation on configuring iAccess to use SSL sessions to include, not just the step-by-step configuration guidance but also a discussion on the benefits and challenges of using certificates from a well-known CA (Certificate Authority) vs a self-signed certificate as well as practical tips for enterprise implementation.