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.