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

March 4, 2015 Volume 14 Issue 5


TOP STORY: Practical SQL: DB2 at Home, Part 3, Using XML Data
FEATURED ARTICLE: RPG Academy: BIF Up Your Code! More on Moving MOVE and MOVEL out of Your Code
NEWS HIGHLIGHT: New IFS Replication Architecture Ensures Maxava HA Continues to Outpace Volume Growth
WHITE PAPER: Business Intelligence for the IBM i Customer
EVENT: The RPG & DB2 Summit - Spring 2015
MC VIDEO PORTAL: Introduction to Configuring iAccess Servers to use SSL

Sponsor - T.L. Ashford & Associates

TLA Forms from TL Ashford is the easiest, most cost-effective way to turn traditional IBMi spool files into Full-Color, professional forms in about 10 minutes! NO Programming is necessary to create forms using text with a wide range of fonts, a full selection of bar codes, including 2-dimensional bar codes, images, overlays, tables, lines, rectangles and circles.

How much time and money will you save yourself and your company? Watch this 2 minute video to learn more, and order a 30-day trial here.


Feature Article - Programming
Practical SQL: DB2 at Home, Part 3, Using XML Data

Now that we have XML data, it's time to learn how to use it.

joe plutaWritten by Joe Pluta

In previous articles (parts 1 and 2), we began to explore DB2's pureXML capabilities. While DB2 provides exceptional XML data-handling, it's not enough to simply be able to store and retrieve XML data. In any real world business application, you'll also need to integrate that XML data with your existing relational data. This article shows how to do just that.


Sponsor - NEUGC

25th Annual Northeast IBM i User Groups Conference

March 30 – April 1, Framingham, MA

The Power of i

- Super Charge Developer Productivity

- Empower User Data Access

- Modernize Your Apps and Database

- Enhance Your Skills

70+ sessions; NEW topics for 2015; top industry speakers; in-depth seminars; vendor expo

Register Today!

Only $550 WITH Monday seminar! View Conference Brochure


Feature Article - Programming
RPG Academy: BIF Up Your Code! More on Moving MOVE and MOVEL out of Your Code

Understanding how to use the EVAL op code and the %CHAR, %EDITC, %EDITFLT, and %EDITW BIFs will help you remove even more of those MOVE and MOVEL statements from your code.

rafael victoria preiraWritten by Rafael Victória-Pereira

One of MOVEL's many uses is the implicit data type conversion from numeric to character. You probably have quite a few of these conversions in your code and don't even realize it. While they're not as error-prone as the reverse operation, it's preferable to have a more controlled conversion, especially because many of these operations are part of something that the end-user will seeeither a message on the screen or a line on a printout, for instance. As usual, there are several ways to do this.


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 White Paper Center

Don't miss these great Featured White Papers:

Business Intelligence for the IBM i Customer

Are you on information overload from the barrage of announcements and ads for BI solutions, including IBM’s new DB2 Web Query V2.1? End the confusion and get informed. This White Paper guides you in evaluating which solution may be the best fit for your company, users, budget, environment and more. It also examines:

  • IBM’s analytics and services strategy
  • the repackaged DB2 Web QueryV2.1
  • IBM’s Cognos solution
  • other BI software in the market

The White Paper offers a comparison of these products with NGS-IQ, NGS’ scalable, proven BI suite of products used by thousands of i customers of all sizes in virtually every industry.

It concludes with a section designed to help IBM i and DB2 supporters explain the strengths of the environment to critics and the uninformed.


Element Break

Cloud Computing

Carol Woodbury discusses the security concerns of cloud computing and provides resources you can check into as you address the security issues of this new technology.


Element Break

Data Access in a Big Data World

With big data comes big responsibility, but it doesn't have to stress you out, especially when it comes to accessing partitioned files. You can learn how to adapt to the trends and take control of your partitioned data without losing the ability to query multiple files at once. Download the free Big Data Access Pack today!
Download Your Free Copy.

Element Break


What Authorities Do Programmers Really Need?


Left to their own preferences, many programmers will ask to be given all possible authorities on the system. That’s because most – not all – but most programmers are focused on getting their work done and would prefer not to be concerned with security. However, many organizations have policies or have to comply with laws or regulations that limit the authorities that programmers can have – especially to production systems. This white paper describes the authorities that programmers typically need along with techniques for determining the exact authorities your programmers need to continue to perform their job functions without having an all-powerful profile.

Element Break

IBM i Scheduling Survival Guide

Survive the climb toward scheduling automation with this indispensable guide. Clear internal and external hurdles, and succeed in each phase of your rollout, from research to implementation.

Our New Must-Have Resource: IBM i Scheduling Survival Guide

Download it free.

Help/Systems has been helping customers automate their IBM i environments for over 30 years.


Element Break

Plus Choose From The Full Selection in the MC Press White Paper Center


*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 White Paper you would like to list? click here or call (208) 629-7275 Ext.504 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.