MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

RE: compiling CLP with RUNSQL statement to previous release V6R1



fixed


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

I use the RUNSQLSEL (Run SQL Select command) written up at
http://wiki.midrange.com/index.php/SQL 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.





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

This mailing list archive is Copyright 1997-2014 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