Preparing To Install IBM’s RUNSQL Command
May 30, 2012 Rob Berendt
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