TechTip: C# for RPGers—Introducing Arrays and the FOR Loop

This time around, I’ll start explaining how to create and handle arrays in C#. It has some similarities to RPG, which will allow you to learn new and interesting C# concepts!

rafael victoria preiraWritten by Rafael Victória-Pereira

C# arrays are somewhat similar to their RPG counterparts, at least in concept. You’ll see that these similarities will allow you to get a grasp on some new concepts, namely the FOR loop.

Book Review: DB2 11 for z/OS Database Administration—Certification Study Guide

This is a well-written DB2 11 book that could easily stand on its own as a reference manual, not just a certification guide.

willie faveroReviewed by William (Willie) Favero

Are you thinking about taking the IBM certification test C2090-312—IBM Certified Database Administrator - DB2 11 DBA for z/OS? After all, it is being offered at no charge at the IBM World of Watson 2016 conference (formerly Insight) and IDUG EMEA 2016, both just around the corner, and at IDUG North America 2017 next spring, also only months away. If you are, you might be facing a bit of test anxiety, even if you know the exam topics well. For many people, the prospect of taking a test can cause them to start questioning their skills.

TechTip: An Easier Way to Search Through Massive Job Logs

Cilasoft offers its new Job Log Explorer tool to the IBM i community at no cost.

guy marmoratWritten by Guy Marmorat

Anyone who has searched through mountains of pages in job logs to find specific program messages during the process of troubleshooting knows all too well how time-consuming and tedious this task can be. In fact, as my team and I have worked with customers and partners over the years, we’ve commonly heard complaints about this very thing. But what’s surprising is there hasn’t been a useful tool available (at least that we could find) to help quickly isolate critical job information in these ungainly job logs. It’s basically a process of repeatedly pressing the F16 (Shift+F4) search key while trying various search terms.

Data-Centric Magic

Everybody is talking about data-centric programming these days. But what is it, and what can it do for, and to, you?

david shireyWritten by Dave Shirey  

Every once in a while, we see a flurry of articles about one particular topic. It blazes forth like a flaming Molotov cocktail, gets tossed up in the air for everyone to see, and then seems to explode in a cloud of smoke. It’s 15 minutes over, the topic quietly goes about the rest of its life, sometimes fading into insignificance and other times taking its place in the hallowed pantheon of IBM i concepts.

SQL 101: Date-Related Functions, Part 4 - Adding and Subtracting Months and Other Neat Date Tricks

After last time’s functions for extracting information from a date, I’ll look into some real date math, with functions that perform some neat tricks.

rafael victoria preiraWritten by Rafael Victória-Pereira

It’s now time to let the system do the so-called “date math” for you. This is an easy task in SQL because there are several intuitive functions to help. Let’s start with ADD_MONTHS. This function has two parameters: a valid date representation and the number of months to add. Here’s an example:

Domino Short and a Fix Pack Late

Domino is dying. But there is hope.

steve pitcherWritten by Steve Pitcher

Last month, I wrote a piece about the future of IBM Notes/Domino called “The Domino 9.0.2 Waiting Game” in which I lamented at the lack of, well, Domino 9.0.2.


Lo and behold, just last week IBM put out an announcement for an update: Notes and Domino 9.0.1 Fix Pack 7. With a whopping 81 fixes combined between client and server since the last update in May 2016, the collective sigh from the IBM Domino user and ISV community certainly wasn’t heard ‘round the world.



IBM Unveils Industry’s First Platform to Integrate All Data Types for AI-Powered Decision-Making

IBM today unveiled “Project DataWorks,” a Watson initiative that is the industry’s first cloud-based data and analytics platform to integrate all types of data and enable AI-powered decision-making. Project DataWorks is designed to make it simple forbusiness leaders and data professionalsto collect, organize, govern and secure data, so they can gain the insights needed to become a cognitive business.

mrc’s e-Learning Portal Helps Users Get More Value out of m-Power

Software developer mrc announces the release of an e-Learning Portal for m-Power users.

“Fractional” CISO Service Now Available for IBM i Environments

Botz & Associates brings ongoing security guidance to small and mid-sized companies.

Benelux Power 2016

Europe’s Smartest IBM Power Expo and Conference

The Weather Company Data Packages Delivers a Set of Cloud-Based Weather Data Services

The Weather Company Data Packages delivers a set of cloud-based weather data services that enable companies across multiple industries to utilize key weather insights to make critical business decisions and improve performance.

IBM Rational Solution for Test Automation V9.0.1

IBM Rational Solution for Test Automation V9.0.1 delivers new capabilities for continuous testing and service virtualization.

IBM Watson Virtual Agent Delivers a Cognitive, Conversational Self-Service Engine for Business

IBM Watson Virtual Agent, a cognitive assistant for business, delivers the following capabilities:

IBM Kenexa Learning Content Management System Premier V10.2

IBM Kenexa Learning Content Management System Premier V10.2 now includes a new authoring interface that combines the ease of use of desktop tools with the collaboration, reusability, and maintainability of a Learning Content Management System.



Introduction to Configuring iAccess Servers to use SSL

To see a list of all the MC Press videos, click here


Tue Oct 04
RPG & DB2 Summit

Events Calendar

October 2016
25 26 27 28 29 30 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5



NEW White Paper Addressing IBM i HA/DR in the Cloud

Connectria Hosting

3 Compelling Drivers for Implementing an HA Solution on an IBM i Cloud with MIMIX




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!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.


Latest Offer from the MC Press Bookstore >>

The MC Press Bookstore runs promotions throughout the week.

Make sure to stop by and check out these Special Deals:
Weekly Collection Sale - Every week an entire Subject is on sale between 15% to 25% off the Sale Price.
9/26 to 9/30 - 25% OFF all RPG books
Monday's Blowout Book - Every Monday check out this DEEPLY discounted book - 50% or more off Sale Price.
9/26 to 9/30 - 50% OFF DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration
Tuesday's 2-Day Sale - Every Tuesday come check out a very special offer on one of our top selling books.
10/04 to 10/05 - 35% OFF IBM Mainframe Security
Thursday's 2-Day Sale - Every Thursday come check out a very special offer on one or more of our books.
9/29 to 9/30 - 35% OFF Data Governance Tools


Check out these New MC Press Books

DB2 11 for z/OS Database Administration: Certification Study Guide (Exam 312) IBM i Security Administration and Compliance: Second Edition Evolve Your RPG Coding: Move from OPM to ILE ... and Beyond DB2 10.5 Fundamentals for LUW (Exam 615)


eBook Special >>

Save 20% Off the Hard Copy Sale Price