Rob, addressing the second issue . . . RUNSQL cannot do a simple SELECT

I use the RUNSQLSEL (Run SQL Select command) written up at but that website seems to be down now.

This custom command uses QMQRY Query Manager to handle SQL syntax (like a SELECT) to then send the results to the screen.
It can also handle any other SQL statement you care to throw at it, like INSERT, UPDATE, DELETE, etc.

- John Voris

from: rob@xxxxxxxxx
subject: RE: compiling CLP with RUNSQL statement to previous release V6R1

The first parameter in other versions may be REQUEST or some such thing.
The second major issue is that the IBM one will not let you do a simple SELECT. . . . to the display.

RUNSQL SQL('select * from routines/dskdtl')
SQL statement not allowed.

This thread ...


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