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
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.