Re: Prompting from stored procedures, is this a thing?

I'm back in front of a 5250 screen(happy new year), the command is STRQMQRY and not RUNSQLSTM
I know you are not interested, but I wanted to give the archives the correct command.
STRQMQRY allows for passing parms and the "select" to be shown on the screen, this how the "old" RUNSQL command worked.


Bryan

Rob Berendt wrote on 1/1/2025 6:29 AM:

Bryan,
Again that is trying to shoehorn SQL into CL. I'm done with that.
RUNSQLSTM does not support a simple SELECT. Instead you're forced to
create a temporary table, output to that, then use some other CL process to
display the contents of that file. Done with it. Done with it. Done with
it.

On Tue, Dec 31, 2024 at 10:01 PM Bryan Dietz <bdietz400@xxxxxxxxx> wrote:

i've not tried with stored procedure, but RUNSQLSTM can be used to run a
sql statement with parms being passed.

happy new year,
Bryan