Re: Using CALL in interactive SQL or ACS SQL scripts

I think this might work in either:
CREATE OR *REPLACE* PROCEDURE rob.deleteme001 (
IN parameter1 *INTEGER*,
INOUT parameter2 *INTEGER*)
LANGUAGE SQL
BEGIN
SET parameter2 = *2* * parameter1;
END;
-- To Test
create or *replace* variable rob.deleteme001 *int*;
call rob.deleteme001(*int*(*1*), rob.deleteme001);
values rob.deleteme001;

On Tue, May 30, 2023 at 10:49 AM VERNON HAMBERG Owner via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Agreed on STRSQL - if it IS possible, it's not going to be obvious, seems
to me.


With ACS, I believe you need something to receive the value for an OUT
parameter - I would expect that to be a global variable - you use the
CREATE VARIABLE statement to make one you can use.


Have never done it, though - so this is just my sense of what it might be.


Cheers
Vern


On Tue, 30 May, 2023 at 9:07 AM, Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:


To: midrange systems technical discussion

By "interactive" do you mean STRSQL? If so, then the answer is probably
not.

On Fri, May 26, 2023 at 6:16 PM Dave <dfx1@xxxxxxxxxxxxxx<mailto:
dfx1@xxxxxxxxxxxxxx>> wrote:

Hi,



Is it possible to use an OUT parameter in interactive SQL or am I limited
to using the CALL with only IN parameters ? If so how do I accomplish

this

?



Thanks
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:

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<mailto:

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<mailto:

support@xxxxxxxxxxxxxxxxxxxx> for any subscription related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
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<mailto:
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<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
--
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.