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

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

Rob Berendt wrote on 12/27/2024 1:22 PM:

It's a possible solution. However I'm tired and done trying to shoehorn
sql into cl by the methods you've outlined and others. I'd sooner call

CL

commands from sql stored procedures. But, since prompting is tough from
stored procedures I'd rather write the whole thing in RPG.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.