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

Written 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!

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

Written 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.

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