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

November 3, 2010 | Volume 9 Issue 21

ISSUE HIGHLIGHTS

TOP STORY: Practical SQL: SQLCOD and SQLSTT
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

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!


Read More >>

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.


Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

Forums Sponsor

POPULAR FORUMS

Forums

Search Sponsor

POPULAR SEARCHES

Search


Read More >>
   MC-STORE.COM