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 9, 2014 | Volume 9 Issue 7


TOP STORY: Modifying a Subfile: Change Is Good, Part 2
FEATURED NEWS: Access Documents via Smartphone or Tablet with LaserVault DMS10 Document Management Solution
NEWS HIGHLIGHT: HelpSystems Adds Data Warehouse and ETL Offerings with Acquisition of RODIN Software Portfolio
ON-DEMAND WEBCAST: Create Amazing, Modern Apps With Profound UI
MC VIDEO PORTAL:  Configuring IBM i iSeries Access Server to Use SSL
EVENT: Implementing Your First BI Solution in an Hour

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
Modifying a Subfile: Change Is Good, Part 2

We started some good stuff in Part 1. Now, let's look at more.

kevin vandeverWritten by Kevin Vandever

Editor's Note: This article is an excerpt from the book Subfiles in Free-Format RPG.


In Part 1, I introduced a technique for modifying data files using subfiles, showing you the DDS and sample screen to let a user update, add, and delete from a name file. In Part 2, we move on to the RPG code.


Sponsor - The MC Press Bookstore

Cool stuff! Check out Subfiles in Free-Format RPG: Rules, Examples, Techniques & Other Cool Stuff. Here’s your chance to learn subfile concepts and programming techniques using free-format RPG. From basic subfile usage to advanced programming, this book offers concepts, explanations and practical examples that reflect current trends. Learn everything from single-page displays to embedded SQL. Includes downloadable templates that include the DDS and RPG code! On sale now for a great low price!


Featured News
Access Documents via Smartphone or Tablet with LaserVault DMS10 Document Management Solution

Anywhere anytime access to critical digital documents supports the needs of a growing mobile workforce.


Sponsor - The MC Press Bookstore

Functions getting you down? RPG expert Jim Martin will rescue you with his helpful guide! Functions in Free-Format RPG IV will build upon your free-format education and teach you how to generate RPG IV programs with functions in the free-format style. This book has everything you need to know about subprocedures, ILE concepts, C functions, and IBM APIs to produce highly modularized programs. You’ll even learn how to write your own custom BIFs. Get your copy today!


MC Webcast Center


Create Amazing, Modern Apps With Profound UI

In this information-packed Webinar featuring IBM Champion Scott Klement and Profound Logic Developer David Russo, you’ll learn why you don’t need to compromise your investment in IBM i to deliver amazing, modern business applications!


  • A patented, drag-and-drop visual designer for easy modernization
  • The first available Handler for RPG Open Access
  • Over 150 built-in rich UI widgets that take your apps beyond anything possible in 5250
  • Integration with a suite of tools that future-proof your applications

  • Watch the on-demand Webinar now!


    Be sure to check out these other useful offerings in the MC Webcast Center. 


    The State of IBM i Security 2014

    5 Steps for Implementing Role-based Access on the IBM i. Presented by Carol Woodbury

    5 Tips for Administering Security in the IFS

    Affordable, Achievable Query, Reporting and Analytics

    Addressing and Automating Audit Requirements for the IBM i

    Auditing the IBM i

    Automating IBM AIX PCI Compliance Reporting

    Automating PCI Compliance Reporting on IBM i

    Beyond FTP, Securing and Automating File Transfers

    Coffee with Carol - Configuring IBM i (iSeries) Access servers to use SSL

    Coffee with Carol: Step by Step Approach to Implementing Object Level Security

    Coffee with Carol: Where do I Start with IBM i Security?

    Common Configuration Mistakes and How to Correct Them

    Dynamic Performance Management for the IBM i: Anticipate System Needs before Issues Happen

    Get Results with NGS-IQ Business Intelligence

    Getting the Most out of Your Audit Journal

    IFS Security

    Introducing ASNA Wings

    Is Your Query Tool Limiting You?

    Managing the Security of Your Data to Meet Your Business Needs

    Mobile Applications for IBM i

    Preparing for and Automating Audit Requirements for AIX

    Programming/RPG - Advanced, Integrated RPG with Tom Snyder

    Security and Compliance: What are the Issues on IBM AIX and How do they Relate to the IBM i

    Security Considerations for IBM i Navigator for the Web

    Simplifying IBM i Security Administration Tasks

    SkyView Security Compliance Solution featuring Audit Journal Reporter.

    The 12 Sections of PCI DSS and How Each Relates to the IBM i Community by Carol Woodbury

    The Hidden Jewels of IBM i Security

    The Top Five RPG Open Access Myths....BUSTED!

    Top 10 New Features of IBM i Security by Carol Woodbury

    Top 10 Security and Compliance Considerations for Cloud Computing

    Understanding the Cost of Downtime

    Unleash the Power of IBM i

    What's New with V6R1 Security

    Why Companies Fail PCI audits


    *Some offers may be limited to U.S. and/or Canadian citizens only. Please see the site for details.

    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 a On-Demand Webcast you would like to list? click here or call (208) 629-7275 for information.




    In the News

    The Latest from IBM

    Support MC Press - Visit Our Sponsors

    Forums Sponsor



    Search Sponsor



    MC Industry Blogs

    Read and Share the latest from the IBM i Automation Blog

    brought to you by HelpSystems


    3 Trends Changing Expectations Inside IBM i Shops

    Released: May 14, 2014. UPDATED: June 18, 2014


    As the IBM i platform closes in on its silver anniversary, there are more than a few operators with ties tracing back to the very beginning. As any one of them can tell you, their roles have likely undergone more changes than the technology itself in that time.

    MC Video Portal

    MC Video Portal

    Configuring IBM i iSeries Access Server to Use SSL

    In this Webinar security expert Carol Woodbury will discuss that several laws and regulations, including the PCI Data Security Standards require that administrators access the system over an encrypted session. Whether you have to comply with one of these regulations or you want to implement this because it's a good security practice, this session will provide the step-by-step instructions for configuring these encrypted sessions. During this webinar, you'll find out how to configure the IBM i using DCM (Digital Certificate Manager) and the steps to configure the clients.