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

September 21, 2016 | Volume 15 Issue 18


LEAD ARTICLE: Data-Centric Magic
FEATURED ARTICLE: SQL 101: Date-Related Functions, Part 4 - Adding and Subtracting Months and Other Neat Date Tricks
NEWS HIGHLIGHT: Benelux Power 2016
EVENT: Class: Introduction to System Operations for IBM i , iSeries and AS/400

Sponsor - ProData Computer Services, Inc.

Securely access and share data using ProData programmer utilities!

DBU - allows access to ALL data on ALL systems using ONE interface. Use DBU to access, analyze and secure data on all your servers. DBU for RDi now available!

RDB Connect - provides direct access to remote data (like MySQL, Oracle, etc.) from all high-level languages on the IBM i.

SQL/Pro - saves time/money by reducing workloads with fast/easy informational retrieval.

Increase productivity with these easy-to-use database utilities.

Download 30 day trial NOW!>>


Feature Article - Programming
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.


Sponsor - BCD Software

What's Possible with PHP on IBM i

Webinar: Tues., Sept. 27 at 1pm ET

This webinar highlights real-world examples of PHP applications that have contributed strategically to IBM i organizations by generating revenue, improving business processes and increasing productivity.

You'll see:

  • B2B/B2C eCommerce applications
  • Inventory, invoicing, order tracking
  • Responsive (mobile-friendly) applications

Sign up now!


Feature Article - Programming
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:


Sponsor - The MC Press Bookstore

With these 101 Dynamite Tips 'n Techniques, Cozzi provides the solutions to dozens of technical dilemmas, gives you insights into resources formerly available only to a select few, and exposes RPG IV extensions that use his vast knowledge of System i MI instructions--all with easy-to-use wrappers that even the most inexperienced RPG IV programmer can implement. Lift the code right out of the book and into your applications!

RPG TnT provides a nearly endless supply of must-have solutions and simple yet powerful RPG tips and tools.

Save 35% off the Current Sale Price Enter Promo Code "2-Day-5120" at Checkout Promo Code valid 09/20/2016 @12:01 am till 09/21/2016 @ 11:59 pm MDT Only


MC SCBG Featured Product

TLAForms by TL Ashford converts your traditional IBM i spool files into high quality, professional forms.

Use a GUI Designer to create forms using data from a spool file and data from your IBM i files. Forms can be designed with true-type fonts, bar codes – including QR Code and Datamatrix, color images, overlays, lines, boxes and ellipses all in full color.

The software generates your forms as PDF documents that are archived to the IFS, automatically emailed and/or printed. Forms can be printed to IBM i PostScript printers, any printer connected to the network, or any printer connected to a PC. IFS locations, email addresses, and printers can be variable based on data within the spool file, data within the IBM i file or spool file attributes.

No programming is required to generate the new forms from your existing ERP, WMS or in-house application software.

The experienced TL Ashford technical support team will provide any pre-designed templates like the VICS Bill of Lading, and make sure working with the software is as easy and productive as possible!


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




Element Break

MC Press Resource Centers


White Papers

Trial Software

 120x90-WOD-MCPOct2015  SB SkyView PPL 5194-120x90  SB HelpSystems ROBOT Generic120x90
Create Amazing, Modern Apps With Profound UI What Authorities Do Programmers Really Need? Easiest Way to Save Money? Stop Printing IBM i Reports
Interested in IBM Power System White Papers, Webcasts and Software solutions? Visit our resource centers today!

Element Break

Check out these current and upcoming Bookstore Deals
Weekly Collection Sale
Monday's Blowout Book
Tuesday's 2-Day Sale
Thursday's 2-Day Sale

5154 200pxl

 See All New Books