IBM recently implemented yet another midrelease command—Run SQL (RUNSQL)—for IBM i OS releases 6.1 and 7.1. The command is implemented with the following PTFs:
V6R1 PTF SI46477 APAR SE51168
V7R1 PTF SI46219 APAR SE51276
Here is IBM’s explanation of the new command:
A new RUNSQL (Run SQL) CL command is provided that accepts an input parameter that is the SQL statement to be run. This will allow an SQL statement to be run directly from an IBM i command line or from a compiled CL program or CL procedure. The new RUNSQL command will support many of the same command parameters as the existing RUNSQLSTM command.
Download the save file containing the source code.