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

November 5, 2014 | Volume 13 Issue 20


TOP STORY: Practical SQL: Listing Based on Group Conditions
FEATURED ARTICLE: RPG Academy: Parameters: Do You Know Your Options?, Part 3
NEWS HIGHLIGHT: mrc Goes Responsive with a New Website and m-Power Applications  
ON-DEMAND WEBCAST: What’s New in V7R2 Security
EVENT: Reporting and Analytics for Manufacturers and Distributors
MC VIDEO PORTAL: Security Admin Tasks - Examining the audit journal

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!


Feature Article - Programming
Practical SQL: Listing Based on Group Conditions

SQL has many features to group and summarize, but you need a little know-how to find the detail under the summaries.

joe plutaWritten by Joe Pluta

If you know me, you know I love Common Table Expressions (or CTEs). In today's article, we're going to take advantage of CTEs and aggregate functions to learn how to find data that matches group conditions. Group conditions come up in many situations, whether it's looking for duplicate items, finding completed orders, or identifying mismatches on denormalized data. I'll show you how to use those group conditions to retrieve the underlying data.


Sponsor - The MC Press Bookstore

In this new release of Data Governance Tools, subject matter expert Sunil Soares walks you through all of the available software tools and shows you how to evaluate them for your program. Soares explains why your organization should consider tools to be a critical component of your data governance program, clarifies how these tools integrate with big data technologies, and shows you how the various software vendors stack up. Pre-order this latest release today!


Feature Article - Programming
RPG Academy: Parameters: Do You Know Your Options?, Part 3

Morphing parameters, C language-like strings, and (sort of) self-formatting parametershidden or at least little know features provided by the OPTIONS keyword. Curious? Continue reading to find out!

rafael victoria preiraWritten by Rafael Victória-Pereira

This is the final article of the options series. If you missed parts 1 and 2, look here and here. And now let's move on!


Sponsor - The MC Press Bookstore

Become a CL Master. Whether you are a novice programmer who needs to get up to speed on the ins and outs of CL or an experienced professional looking for a daily CL reference, this comprehensive book is the guide you need. Available in both hard copy and eBook formats. Click now for a free chapter or to learn more. >>


MC Webcast Center

Don't miss these Featured On-Demand Webcasts:


What’s New in V7R2 Security

During this Coffee with Carol session Carol Woodbury will discuss the security enhancements added to V7R2 including:

  • new auditing options,
  • password composition rules,
  • general updates as well as
  • the DB2 security enhancements – RCAC (Row and Column Access Control.)Element Break

Introduction to Configuring iAccess Servers to use SSL Presented by Carol Woodbury

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.

Element Break



Coffee with Carol: I want my Privacy!


Whether you are a cloud provider or a consumer of cloud technology, this session will apply to you. Using a consumer's point of view, Carol Woodbury will discuss the security considerations you'll want to make when choosing a provider as well the security measures you can expect from various types of cloud providers. Also discussed will be the types of audits that the cloud provider can supply to provide assurances of security and privacy of data.

Element Break



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

Element Break



See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

Element Break

Plus choose from the Complete Collection in the MC Press Webcast 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 Webcast 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

Security Admin Tasks - Examining the audit journal

In this informative video:  Carol Woodbury, President of SkyView Partners, discusses the security administration requirement to view audit journal entries on a daily basis and how that can realistically be accomplished using SkyView's Audit Journal Reporter product.