RE: Can SQL recognize a nested data structure?

[CWilt@xxxxxxxxxxxx]

Guy,

It works fine.  But there are a few things to keep in mind:

Given
c+ fetch from c1 for 10 rows into :wData

1) wData must be defined as a MODS not an array (unless at v5r3)
2) wData can't be qualified ( unless at v5r3)
3) wData can only be defined once in the program (unless at v5r3???)

as far as #3 goes, the pre-compiler expects wData to be a global DS.
However, I've used a local DS successfully just remember not to reuse the
same name in another procedure.  

HTH,
Charles


> -----Original Message-----
> From: Guy Henza [mailto:guyhenza@xxxxxxxxxxx]
> Sent: Wednesday, August 18, 2004 8:22 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: Can SQL recognize a nested data structure? 
> 
> 
> I love it when I find a new snippet of code that works.  I've 
> been playing 
> around with
> 
> c+ fetch from C1 for 10 rows into :..
> 
> for a while and can't get past
> 
> SQL0221  30      15  Position 23 Number of rows 10 not valid.
> 
> Does this line actually work somewhere?  Will someone please 
> post an example 
> of it working.
> 
> Thank you all,
> 
> Guy
> 
> PS: I was able to get the iimds example to compile using a 
> single occurrence 
> data structure but not a multiple occurrence data structure.
> 
> _________________________________________________________________
> Is your PC infected? Get a FREE online computer virus scan 
> from McAfeeョ 
> Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>