Re: Using CALL in interactive SQL or ACS SQL scripts

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.