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

January 9, 2015 | Volume 12 Issue 1


TOP STORY: TechTip: Combining Multiple Row Values into a Single Row with SQL in DB2 for i
FEATURED ARTICLE: TechTip: The Need to Modernize IBM i Databases: Why and How? 
NEWS HIGHLIGHT: HelpSystems Acquires Multi-Platform Systems Management Provider Halcyon Software
TRIAL SOFTWARE: Try the Most Powerful Anti-Virus Protection for IBM i for Free!
EVENT:  SkyView Deep Dive Security Training for IBM i
MC VIDEO PORTAL: The 12 Sections of PCI DSS and How each Relates to the IBM i Community


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 - TechTip
TechTip: Combining Multiple Row Values into a Single Row with SQL in DB2 for i

Leverage recursive SQL to pivot row values into a single column.

kent milligan 117x117Written by Kent Milligan

Often, when looking at a report, a user prefers to see similar values grouped together on a single line of output instead of having those values spread across multiple lines of report. An example of that type of report is displayed in the table below. For each automobile make, the report lists all of the models that are currently in inventory in a single row of the report.


Feature Article - TechTip
TechTip: The Need to Modernize IBM i Databases: Why and How?

You can modernize IBM i databases without "breaking" what already works.

elie muyalWritten by Elie Muyal

When speaking about the modernization of the IBM i, usually the first thing that comes to mind is the modernization of the user interface, since it's the visible part of the application. Although it's clear that the benefits of revamping the green-screen user interface are considerable, it's important to remember that the user interface is only a means to access and update the database. The database holds the information, which is the most important asset of any organization.


Sponsor - The MC Press Bookstore

An old dog can learn new tricks! Flexible Input, Dazzling Output with IBM i is full of clever ways to get data into your IBM i system, as well as new techniques to export and present this data in a modern, business-friendly manner. No more boring spreadsheets or ugly printouts! Your DB2 data will look great in program-generated spreadsheets and browser-based, interactive charts. Whether you’re an old dog or not, you’ll get the most out of your ILE RPG programs with the open source, free tools in this smart new release! Order your copy today!


MC Software Center

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

Think you don’t need virus protection on IBM i? Here’s why you do:

- The IFS is vulnerable and most modern applications and protocols use it.

- Viruses can hide inside Java and UNIX files, and IBM i can execute them.

- Anything an administrator can do, a virus can do.

And it’s not just viruses in the traditional sense. Many types of malicious code can compromise your security. And as the news shows, these breaches happen all the time. Fortunately, it’s easy to protect your IBM Power Systems with StandGuard Anti-Virus. Key feature include:


  • McAfee Scanning Engine
  • Native applications for IBM i, AIX, and Linux
  • Protection for Lotus Domino
  • Object Integrity Scanning

Try it 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



Search Sponsor



MC Video Portal

MC Video Portal

The 12 Sections of PCI DSS and How each Relates to the IBM i Community


In this session, Carol Woodbury draws on her experience consulting with SkyView Partners' clients and helping them with their PCI DSS implementation and compliance requirements. Carol explains each of the 12 sections of the Payment Card Industry's Data Security Standards (PCI DSS) and describes specifically how each relates to the IBM i community.