Re: Syntax for calling stored procedure

["Brian Johnson" <brian.johnson.mn@xxxxxxxxx>]

Similarly, in RPG...

exec sql call gnodgdf/getShortSKU ( :sSKU, :Cmpny, :Sld2, :Itm ) ;



On 9/10/07, Alan Campin <Alan.Campin@xxxxxxxxxxxxxxxx> wrote:
> <snip>
> I got the message indicating that it was successfully created.
>
> Now the question.  How do I call it ?  Can I test this interactively
> from STRSQL or Iseries Navigator RUNSQL Scripts ?
>
> What's the correct syntax ?
> </snip>
>
> Use Run Sql Scripts in Ops Nav
>
> Call gnodgdf/getShortSKU ('SKU1', '001', '100', '3410')
>
>
> --
> 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.