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

January 7, 2015 | Volume 14 Issue 1


TOP STORY: Practical SQL: DB2 at Home, Part 1, the Environment
FEATURED ARTICLE: RPG Academy: BIF Up Your Code! Get Rid of Those File-Related Indicators
NEWS HIGHLIGHT: Continuous Update of Live Applications with TD/OMS from Remain Software
MC PRESS BOOKSTORE: New Year's Sale: EXTRA 15% OFF the Top 15 Bestsellers for 2014
EVENT: Looking for a Complete RFID Solution for Retailers? See EdgeMagic for Retail LIVE
MC VIDEO PORTAL: The 12 Sections of PCI DSS and How each Relates to the IBM i Community

Feature Article - Programming
Practical SQL: DB2 at Home, Part 1, the Environment

DB2 is IBM's universal database, and that means you can learn about it at home without an IBM i!

joe plutaWritten by Joe Pluta

One of the great features of the IBM midrange platform is its integrated database. For the longest time, we midrange programmers didn't even have a name for the database; we just knew how to access it with RPG and later with SQL. But as IBM targeted other platforms, they put everything under the umbrella name of DB2, the name of the mainframe DBMS. Today you can get DB2 on your home computer so that you can test the latest and greatest features at your leisure. It does, however, take some thought as to how you want to set it up, and this article gives you some input into that decision-making process.


Sponsor - The MC Press Bookstore

Don't miss out! This is the hands-on guide to IBM's strategic language for IBM i. Database Design and SQL for DB2 delivers everything you need to know about database design and SQL. Author Jim Cooper gives you all the tips and techniques you need in one convenient place, whether you’re a beginner or an advanced developer. Includes real-life examples to help you hone your skills. The bonus companion website explains embedded SQL and explores client-side technologies.


Feature Article - Programming
RPG Academy: BIF Up Your Code! Get Rid of Those File-Related Indicators

Throughout this series, I've mentioned BIFs several times. It's time to explain a few of them in detail, starting with a couple of almost-magical BIFs that rid your code of those pesky file-related indicators. Interested? Keep reading.

rafael victoria preiraWritten by Rafael Victória-Pereira

We all use a built-in function (BIF) or two in our code, even if we don't quite understand how they work. Here and in upcoming TechTips, I'll discuss an assortment of BIFs that will, hopefully, help you to BIF upsorry, I mean beef upyour code: you'll improve readability, avoid "reinventing the wheel" by writing code that emulates the functionality of a BIF, and make yourself (and your code) more efficient.


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!


MC Video Portal

MC Video Portal

The 12 Sections of PCI DSS and How each Relates to the IBM i Community


In this session, Carol Woodbury draws on her experience consulting with SkyView Partners' clients and helping them with their PCI DSS implementation and compliance requirements. Carol explains each of the 12 sections of the Payment Card Industry's Data Security Standards (PCI DSS) and describes specifically how each relates to the IBM i community.


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