RE: Arrays of arrays

[Francois Lavoie <Francois.Lavoie@xxxxxxxxxxxxxxxxxxxx>]

Or best, calculate the exact length of the iniziative array and multiply by 999

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Maria Lucia Stoppa
Sent: Monday, April 20, 2020 14:32
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Arrays of arrays

@Francois: I issed this part "And, redefine the iniziative array to a 65535 char variable and dsIniziativa dim(999) then move iniziative to dsIniziativa for each fetch".
I'll give it a try!

Il giorno lun 20 apr 2020 alle ore 20:29 Maria Lucia Stoppa < mlstoppa@xxxxxxxxx> ha scritto:

> Thank you all!
>
> @Raul, @DlClark: I supposed the issue could have been connected with 
> nidification.
> @Charles: for each fetched agent a subsequent multiple rows select 
> would be done to fill in "initiative"; it's just under "(rest of the code)" tag.
> @Charles, @Francois: true, the number of fetched fields is incomplete 
> because the "initiative" field is supposed to be filled in by code 
> that follows. Also, I tried to pass an empty dsIniziativa, but it didn't work.
>
> So, I thought arrays of arrays could be managed by SQL, which is not. 
> I'll figure out how to manage the data layout to achieve my goal.
> Thank you again.
>
> Il giorno lun 20 apr 2020 alle ore 17:05 Francois Lavoie < 
> Francois.Lavoie@xxxxxxxxxxxxxxxxxxxx> ha scritto:
>
> > I noticed that the number of fields Selected don’t match the DS 
> > definition
> >
> > Select                                      DS
> > trim(agn.ageagn)                  codice
> > trim(age.agras)                      nominativo
> > trim(age.agtel)                       telefono
> > trim(age.agmail)                    email
> > trim(agx.prpec)                      emailPEC
> > trim(agn.agegnz)                   agenziaId
> > agx.prdim                               inizioMandato
> > 0                                               iniziativeAttive
> > ??                                             iniziative
> >
> > And, redefine the iniziative array to a 65535 char variable and 
> > dsIniziativa dim(999) then move iniziative to dsIniziativa for each 
> > fetch
> >
> > HTH
> >
> > -----Original Message-----
> > From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of 
> > raul
> > Sent: Monday, April 20, 2020 10:05
> > To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> > Subject: Re: Arrays of arrays
> >
> >
> >
> > SQL still has some limitations on the use of data structures. You may 
> > have to move to an auxiliary field.
> >
> > El 20-04-2020 07:20, Maria Lucia Stoppa escribió:
> >
> > --
> > 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
>
>
> --
>
> Maria Lucia Stoppa
> mlstoppa@xxxxxxxxx