Re: Stored Procedure with large result set

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

There is no 32K array size limit in RPG Charles.

Jon P.


> On Apr 7, 2022, at 1:00 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
>
> I assume this is an RPG program/prodedure being used as a SQL externally
> defined stored procedure?
>
> How is the RPG generating the results set?
>
> Sounds like you're trying to build an array(?) in RPG and return that as a
> result set?
> And running into RPG limits, in that case nope.
>
> You'd need to switch to using an SQL cursor to return a bigger result set.
>
> Charles
>
> On Thu, Apr 7, 2022 at 10:54 AM (WalzCraft) Jerry Forss <
> JForss@xxxxxxxxxxxxx> wrote:
>
> > Hi All,
> >
> > I have a request for a Stored Procedure that will return a result set with
> > around 50,000 rows.
> > It seems the limit is set at around 32,000 rows, otherwise the pgm will
> > not compile.
> >
> > There are over 3 million records in the file that I want to return a
> > subset.
> > This is called from the network side of the world.
> >
> > Is there any way around this limit?
> >
> >
> >
> > 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
> -- 
> 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