Re: SQLRPGLE - can I have two cursors open at the same time?

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

I do it but I always try and make an effort (and at least ask myself) can I include this second looped data set in the primary dataset query and prevent the secondary dataset looping. 

Jay

> On Apr 18, 2019, at 4:35 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:
>
> I am doing it at this moment. The other loop opens a cursor on a table and
> reads a table in 32,766 records at a time and processes each record by
> record opening cursors on 4 or 5 different tables. I haven't seen any
> instances of problems.
>
> On Thu, Apr 18, 2019 at 1:25 PM Greg Wilburn <
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> > I've done it before... you have to be careful with the SQL Code and State.
> >
> > I'm not sure how to manage those (pretty green at this) when you have two
> > files (errr umm "Tables") open...
> >
> > -----Original Message-----
> > From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
> > Booth Martin
> > Sent: Thursday, April 18, 2019 4:21 PM
> > To: RPG programming on the IBM i (AS/400 and iSeries) <
> > rpg400-l@xxxxxxxxxxxxxxxxxx>
> > Subject: SQLRPGLE - can I have two cursors open at the same time?
> >
> > can I open & close a cursor fetch loop inside another cursor fetch loop?
> >
> > --
> > 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@xxxxxxxxxxxx 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@xxxxxxxxxxxx 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@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com