MAGAZINES

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

July 20, 2016 | Volume 15 Issue 14

ISSUE HIGHLIGHTS

LEAD ARTICLE: SQL 101: Date-Related Functions, Part 2—Time-Saving Functions
FEATURED ARTICLE: What IBM i Execs Should Know, Part 2
NEWS HIGHLIGHT: Gravity Task and Workflow Management Version 1.1 Release
BUYER'S GUIDE: TLAForms
EVENT: Build Web Apps in 30 Minutes and 1 Language

Sponsor - The MC Press Bookstore
 

One Book Gets You There!

Ace exam 312 with the latest DB2 certification study guide from MC Press. One book gives you all you need to know about the core DB2 11 for z/OS topics. Author Susan Lawson—who also helped develop exam 312—introduces DB2 11 for z/OS and gives you a comprehensive review of database design and implementation, applications and database functionality, environment management, data management, and more! Features 90 practice questions & answers. Order your copy today.


Read More >>

Feature Article - Programming
 
SQL 101: Date-Related Functions, Part 2—Time-Saving Functions

The functions discussed in this article won’t save time in the literal sense; mankind has yet to invent a time machine. However, these functions will surely cut down on the time it takes an RPG programmer to perform complicated “date math.”

rafael victoria preiraWritten by Rafael Victória-Pereira

As I mentioned in the previous article, there’s no BIF to return the day of the week, for instance. SQL provides several simple-to-use scalar functions that do that and more, as you’ll see later in this article.

 

Before getting to that, let me take a moment to address some readers’ remarks regarding the functions I presented in the previous article.


Read More >>

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!


Read More >>

Feature Article - Operating Systems
 
What IBM i Execs Should Know, Part 2

Oooh. Executives. Sounds so very sophisticated, doesn’t it? Handsome guys in expensive suits who go to clubs like Laslo’s after work and meet up with slender, willowy brunettes for a martini. Very classy.

david shireyWritten by David Shirey

OK, it’s time to talk a bit more about what IBM i managers and executives should know.

 

When we left off last time, we had identified two things that “i leaders” need to be familiar with: what makes the i special and what’s up with the Power architecture these days and why it’s a better choice than Intel for the long haul. But that’s not the end of the story. Come on, walk this way.


Read More >>

Sponsor - The MC Press Bookstore
 

Relax…he knows his stuff! You’ll be sure to pass Exam 615 with the help of DB2 expert Roger Sanders. He helped develop Exam 615 plus 22 other certification exams. This is the latest in the popular MC Press DB2 Certification Study Guide series. Get all you need to know about DB2 10.5 for Linux, UNIX, and Windows. This guide includes a complete practice exam with 125 questions and answers. Nothing will prepare you more for the DB2 10.5 Fundamentals for LUW exam! Order your copy today.


Read More >>

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!


Read More >>

In the News

Vendors:  Have a press release to share?  Send it to MC Press.


Read More >>
The Latest from IBM

Read More >>
Support MC Press - Visit Our Sponsors

Forums

Search Sponsor

Search

MC Press Resource Centers

Webcasts

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!


Read More >>
   MC-STORE.COM