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

November 3, 2010 | Volume 9 Issue 21


FEATURED ARTICLE: Are RPG Programmers RPG's Worst Enemy?
NEWS HIGHLIGHT: COMMON Belgium Brings the Roots of IBM Power Systems to IT Youth
FORUM: Importing Excel Worksheets to Database Files
MC STORE: Top 10 Best-Selling Titles for October 2010
Manage Subscription | Contact Us

Sponsor - ASNA Wings

Introducing ASNA Wings ASNA’s latest evolution of its award winning automated migration technology is here. This exciting offering from the System i Modernization leader allows you to quickly, automatically and inexpensively modernize that green screen user interface that has been holding you back. Wings takes advantage of IBM’s Rational Open Access RPG Edition, and can be used as a complete approach if an enhanced interface is all that you need…



Feature Article - Programming
Practical SQL: SQLCOD and SQLSTT

This article compares SQLCOD and SQLSTT and shows you how to avoid one of the primary gotchas you face when using SQLSTT.

joe_plutaWritten by Joe Pluta

Embedded SQL programming is one of the most productive additions ever made to the IBM i development environment. But it's rarely used to run the traditional example statements you see in the SQL programming books: statements that increase the price of every item by 15 percent. Instead, the most often used construct in the embedded SQL toolkit is the cursor, which essentially provides a dynamically built logical file to your RPG program. And like any logical file, an essential part of using the file is knowing when you've hit the end. RPG provides two variables: SQLCOD and SQLSTT. SQLSTT is the more standard technique, but its improved accuracy does not come without some cost. Fortunately, that cost is pretty low, and I'll even pick up the tab!


Feature Article - Programming
Are RPG Programmers RPG's Worst Enemy?

When you try to use new techniques and technologies, do you get resistance from your own staff?

tom_snyderWritten by Tom Snyder

Are you an RPG programmer who is dealing with resistance to updating your RPG skills from people in your staff or even management within your staff? Well, you're not alone.


I felt compelled to write this article because I have received several emails from people who are interested in updating their RPG skills, but the environment that they work in discourages skill advancement. Recently, I received a message from someone who is literally on the other side of the planet and is experiencing this kind of oppression in his shop and other shops that he's worked in.


Most Popular MC Press Books

Top 10 Best-Selling Titles (Updated November 2010)

  1. SQL for eServer i5 and iSeries
  2. The Modern RPG IV Language, Fourth Edition
  3. The IBM i Programmer's Guide to PHP
  4. Free-Format RPG IV
  5. You Want To Do WHAT with PHP?
  6. Advanced, Integrated RPG
  7. Functions in Free-Format RPG IV
  8. SQL Built-In Functions and Stored Procedures
  9. XML for eServer i5 and iSeries
  10. Programming in RPG IV, Fourth Edition




In the News

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor