Re: Stored Procedure Returning Multiple Result Sets

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Just tell the Db you've got two

exec SQL
  set results sets with return to client
     array :myarr1 for :arry1Rows ROWS
     ,  array :myarr2 for :arry2Rows ROWS;

also on the SQL CREATE PROCEDURE declaration, specify RESULTS SETS 2

Charles

Charles

On Thu, Sep 29, 2022 at 10:45 AM (WalzCraft) Jerry Forss <
JForss@xxxxxxxxxxxxx> wrote:

> I have done a bazillion Stored Procedures returning a single result set.
>
> Is it possible to return more than 1?
>
> If so, an example would be wonderful!
>
>
>
> Subject to Change Notice:
>
> WalzCraft reserves the right to improve designs, and to change
> specifications without notice.
>
> Confidentiality Notice:
>
> This message and any attachments may contain confidential and privileged
> information that is protected by law. The information contained herein is
> transmitted for the sole use of the intended recipient(s) and should "only"
> pertain to "WalzCraft" company matters. If you are not the intended
> recipient or designated agent of the recipient of such information, you are
> hereby notified that any use, dissemination, copying or retention of this
> email or the information contained herein is strictly prohibited and may
> subject you to penalties under federal and/or state law. If you received
> this email in error, please notify the sender immediately and permanently
> delete this email. Thank You
>
> WalzCraft PO Box 1748 La Crosse, WI, 54602-1748
> www.walzcraft.com<http://www.walzcraft.com> Phone: 1-800-237-1326
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-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