Re: How do I test an SQL procedure (with parameters) using Run SQL Scripts?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I thought you could just use CALL...

Per the FAQ, output parms are returned in the messages tab
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzate/rzatefaq.htm#rzatefaq__store1

I assumed they output value of an INOUT parm would be also...

Is that not the case?

Charles



On Mon, Feb 20, 2017 at 8:48 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

> I have a procedure created with:
> CREATE PROCEDURE ROUTINES/GDSSYS002
>   (INOUT sysasp INT ,
>    INOUT pctsysasp INT,
>    INOUT PctPerm INT ,
>    INOUT PctTemp INT )
>   LANGUAGE RPGLE
>   NOT DETERMINISTIC
>   CONTAINS SQL
>
> It was created prior to the advent of stuff like
> SELECT
>   System_Asp_Storage, System_Asp_Used, Permanent_Address_Rate,
> Temporary_Address_Rate
>  FROM TABLE(QSYS2.SYSTEM_STATUS()) X;
>
> I am having an issue calling it on a new lpar.  The procedure exists (not
> just the RPG program but the actual procedure).
> I would like to test it from "Run SQL Scripts".  How do I do so?
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD