I’ve often needed to run a SQL statement from within a CL program. I knew I could by calling a RPG program with SQL embedded in it, or by executing RUNSQLSTM, but I really didn’t want to go to that much trouble to run one simple SQL statement.

IBM has given you a way to run an SQL command within a CL procedure if you’re running IBM i 6.1 or 7.1. It’s a new CL command called RUNSQL. For 7.1, you must order level 14 or higher of DB2 PTF Group SF99701. For 6.1, order level 25 or higher of

Today I want to share with you some of the ugliest RPG code I’ve ever seen. It is to me the programming-language equivalent of Quasimodo, the hunchback of Notre Dame, and I am its progenitor. Then I will tell you why I wrote this code, and why, despite its ugliness, the code was correct. Last, I will tell you how to “prettify” it.

The ugly code of which I speak is in a template source code member for file maintenance programs. It is similar in structure to this example:

     P MoveItem        b
     D                 pi
     D  inItemID                      6a   const
     D  inWhsID                       

I tried mapping a Windows drive letter to the root folder (/) of my Integrated File System (IFS) by using an IBM i NetServer file share. But I can’t get the drive to map. My cubicle buddy can map her drive. Why can’t I map my drive?

–Phil

Just as your IBM i user profile can be disabled from signing on to the system after a set number of incorrect sign-on attempts, the system can also automatically disable your user profile from IBM i NetServer access after you exceed the maximum number of sign-on attempts when trying to access a