Re: new IBM RUNSQL command

On Fri, 30 Mar 2012 15:15:15 +0000, "Stone, Joel"
<Joel.Stone@xxxxxxxxxx> wrote:

Thanks for the great article Bruce!

One question - hundreds of custom RUNSQL type commands have been custom-built at hundreds of iseries shops over the years.

These commands are used in production.

How can shops ensure old CL runs will continue to call their home-grown RUNSQL command (instead of the new IBM RUNSQL command?)

This will surely cause havoc in many shop, as parm names will not match and abends will occur in production jobs, some without source (for packages, etc).

Yes, thanks for the article Bruce.

And thanks for the heads-up Joel.

We have a command that came as part of a purchased software package,
and I checked and sure enough, it's called RUNSQL.

Neither the software package nor the application of PTFs are my direct
responsibility, but I've notified the appropriate people, with the
recommendation that we make a copy of the RUNSQL command to a new
name, then change all of the programs to use the new name, then delete
RUNSQL. (Some of the programs which use the RUNSQL command are my
direct responsibility.) Fortunately the software package itself
appears to not use the RUNSQL.

Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.