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

February 13, 2015 | Volume 12 Issue 6


TOP STORY: TechTip: More on Combining Multiple Row Values into a Single Row with SQL in DB2 for i
FEATURED ARTICLE: Book Review: 5 Keys to Business Analytics Program Success
NEWS HIGHLIGHT:  HelpSystems Partners with SoftLanding Systems to Enhance Change Management Solution for IBM i
TRIAL SOFTWARE:Hassle-Free IBM i Operations around the Clock
EVENT: OCEAN User Group Meeting: PHP, HTML, CSS, JavaScript, and jQuery
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 - TechTip
TechTip: More on Combining Multiple Row Values into a Single Row with SQL in DB2 for i

Leverage recursive table expressions to pivot row values into a single column.

kent milligan 117x117Written by Kent Milligan

After my last article, I had a number of readers express interest in a solution that would work on servers running pre-IBM i 7.1 operating system release levels. Luckily, recursive SQL capabilities were first made available with the DB2 for i V5R4 release, so this article will provide a solution that can run on release levels of V5R4 and newer.


Sponsor - Profound Logic Software

February 25, 2015 | 8:30 PST/11:30 EST
Make 2015 the year of modernization in your company! It’s easy with tools from ARCAD Software and Profound Logic Software.

ARCAD and Profound Logic have partnered to provide the most comprehensive solutions for database, code and application modernization.

Attend their February 25 Webinar and learn how modernization will help you:

  • Reduce Costs
  • Minimize Risks
  • Future-Proof Technology
  • Improve User Satisfaction

Register for the Webinar now!


Feature Article - Database
Book Review: 5 Keys to Business Analytics Program Success

From business intelligence to business analytics: a road to rapid success.

kesar sandhuWritten by Kesar Sandhu

5 Keys to Business Analytics Program Success (MC Press, 2012) is a relevant publication in view of increasing consumerism, in order to understand the class, style, and preferences of consumers, which change on a daily basis. Analytics is a tool that helps businesses identify trends and make decisions. Marketing has evolved from a creative process into a highly data-driven one, and marketing organizations now use analytics to determine the outcomes of campaigns or efforts and to guide investment and consumer-targeting decisions.


Sponsor - The MC Press Bookstore

Learn the Secrets to Success with Business Analytics

Business Analytics leads to higher business performance and helps organizations outperform their peers by 2.2 times (according to a recent IBM Institute for Business Value study). But many organizations struggle to create impact using Business Analytics. Now, 5 Keys to Business Analytics Program Success reveals the key aspects behind the success of some of the top BA programs in the industry. Find out how the Business Analytics Program can help you manage strategy, value, people, process, and technology to translate analytic strategy into actionable insight and achievement.  Get your copy today!


MC Software Center

Hassle-Free IBM i Operations around the Clock

For over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks.

Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • Automated batch, interactive, and cross-platform scheduling
  • Event-driven dependency processing
  • Centralized monitoring and reporting
  • Audit log and ready-to-use reports
  • Seamless product integration
  • Scale your software, not your staff.

Try the Robot Job Scheduling Solution 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

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.