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

June 24, 2016 | Volume 13 Issue 25


LEAD ARTICLE: SQL 101: Date-Related Functions, Part 1—Converting Almost Anything to a Date, Time, or Timestamp
FEATURED ARTICLE: Book Review: Free-Format RPG IV, Third Edition
FEATURED NEWS: Maxava iFoundation Invites IBM i User Community to Apply for 2016/17 Funding
NEWS HIGHLIGHT: Remain Software Releases the New CA 2E Interface
EVENT: How to Confront Your IBM i Message Queues

Sponsor - The MC Press Bookstore

This ain’t your mama’s RPG! Time to move on from OPM—with Evolve Your RPG Coding. This comprehensive new book gives you all the tools to move to a more modern, modular, and efficient ILE RPG. The book guides you through the transition at a comfortable pace, making every ILE concept totally accessible. You’ll start with simple, easy-to-understand examples and analogies to OPM, then advance to complete and complex ILE code. Finally, you’ll go beyond ILE with a detailed discussion of SQL, code organization, and structure. Pre-order your copy today!


Feature Article - Programming
SQL 101: Date-Related Functions, Part 1—Converting Almost Anything to a Date, Time, or Timestamp

This subseries will cover the main date- and time-related functions SQL has to offer, providing examples of possible applications of this interesting and useful set of scalar functions.

rafael victoria preiraWritten by Rafael Victória-Pereira

I’ll start by showing how to convert other data types to Date, Time, and Timestamp data. Handling dates and times in RPG has always been a pain. It’s true that the new-ish BIFs help a lot, but apparently simple tasks such as determining the day of the week of a given date or finding out when will the next Monday occurs require loads of RPG code to implement. SQL offers a very interesting set of scalar functions that can really help when it comes to handling date-related data.


Sponsor - The MC Press Bookstore

Have you heard? RPG is now fully free-format! This latest edition from RPG expert Jim Martin is your one-stop resource for free-format information. It’s a must-read for all RPG programmers, featuring completely updated code. See the new H, F, D and P specs in action in this easy-to-use reference guide. You’ll learn rules and syntax but also grasp how this modern style of coding can improve your overall productivity--from initial development through maintenance. Get your copy today!


Feature Article - Programming
Book Review: Free-Format RPG IV, Third Edition

Jim Martin comes through for us again.

joe plutaReviewed by Joe Pluta

Some time ago, I had the privilege of reviewing Jim Martin’s Functions in Free-Format RPG IV, and I was immediately struck by how Jim can take a complex subject and make it accessible to IBM i programmers. His newest book, Free-Format RPG IV, Third Edition, carries on that tradition wonderfully.


Sponsor - The MC Press Bookstore

Nail Exam 311! This new book will show you how. Get the newest release in the MC Press DB2 Certification Study Guide series from leading DB2 authority Roger Sanders. Sanders helped develop Exam 311 and 23 other DB2 certification exams. This new book is all you need to prepare and pass the exam in one handy, concise guide. Includes 56 practice questions and answers that model the exam. Get your copy today!


Featured News
Maxava iFoundation Invites IBM i User Community to Apply for 2016/17 Funding

The Maxava iFoundation is once again delighted to announce a new funding pool to assist IBM i user groups following the record number of applications granted for 2015/16.


MC SCBG Featured Products

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



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!