RE: Can SQL recognize a nested data structure?

I use them anyplace I need a set of records at a time.

For example, I need 10 records to populate a subfile.

Or I need 30 records to print a page of labels.

Even if there's no defined limit to the records I need at once, there's some
performance improvements to processing blocks of records at a time using
multiple row fetch.


I don't think an SQL stored procedure can define the host array needed to
use a multiple row fetch.  But I supposed one could be passed in as a
parameter.  I'm not sure how useful that would be though.

Charles


> -----Original Message-----
> From: SRamanujan@xxxxxxxxxxxxxxxxxx 
> [mailto:SRamanujan@xxxxxxxxxxxxxxxxxx]
> Sent: Tuesday, August 17, 2004 3:35 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: Can SQL recognize a nested data structure?
> 
> 
> Where is a multiple row fetch used usually?  Can a stored proc use it?
> But we don't need to fetch and can just pass the cursor itself I
> thought. 
> 
> Thanks, 
> Sudha
>