Re: Calling stored procedure from ACS RUN SQL with return parameters

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Add in your output parms as ?...

PGMLIB.OEXX55S('Parm1','Parm2':?:?);

Charles

On Wed, May 26, 2021 at 1:52 PM Ken Meade <kmeade@xxxxxxxxxxxxxxxxx> wrote:

> I'm trying to test a stored procedure that is returning parameters and I
> thought in the past I could do this in the ACS RunSQL tool.
> If I call a stored procedure that doesn't return a parameter, the call
> appears to work. But when I do the same with one that is expecting returned
> parameters I get the error message: [SQL0440] Routine OEXX55S in PGMLIB not
> found with specified parameters. However I've confirmed the object exists
> and has the correct inbound parameters. I've also validated my
> authorization associated with the object. I'm just doing a simple call
> PGMLIB.OEXX55S('Parm1','Parm2');
>
> Thanks,
> Ken
>
>
>
>
>
> Ken Meade | Director of Information Technology
>
>
> [ mailto:kmeade@xxxxxxxxxxxxxxxxx | kmeade@xxxxxxxxxxxxxxxxx  ] | (603)
> 444-3570
>
>
>
>
>
> Littleton Coin Company, Inc.
>
>
> 1309 Mt Eustis Rd, Littleton NH 03561
>
>
> [ http://www.littletoncoin.com/ | www.littletoncoin.com ]
>
>
>
>
>
>
>
>
>
>
>
>
> --
> 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.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com