IBM's RUNSQL command came out with certain PTF's.
It exists in QSYS
Command . . . . . . . : RUNSQL Library . . . . . . . : QSYS

Program to process command . . . . . . : QSQSCHEM
Library . . . . . . . . . . . . . . : QSYS

There's two major issues with it, and the third party products that came
The first being the parameter names have changed. This is the #1 killer
with imbedded versions of RUNSQL. The first parameter in the IBM version
is SQL. The first parameter in other versions may be REQUEST or some such
The second major issue is that the IBM one will not let you do a simple
RUNSQL SQL('select * from routines/dskdtl')
SQL statement not allowed.

Another issue is that the IBM version defaults to running under some sort
of commitment control so you often have to
If you're not journalling, or you do not want to forget to 'commit' your

Rob Berendt

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact