RE: Unlimited size result sets

[CWilt@xxxxxxxxxxxx]

Buck,

Just read an article about Client-side cursors with ADO.

Sounds like what you are looking for, but I don't know if you can do the
same in Java.

Anyway, here's a link to the article:
http://www.midrangeserver.com/mgo/mgo121703-story01.html



HTH,
Charles


> -----Original Message-----
> From: Buck [mailto:buck.calabro@xxxxxxxxxxxx]
> Sent: Wednesday, December 17, 2003 4:47 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Unlimited size result sets
> 
> 
> Yes it's me again.  My Java person insists that she wants me 
> to return 500k+
> rows of data to her in a result set.  Those of us on the 
> iSeries side think
> this is not a good idea.  She says that this is how things 
> work in the real
> world (as opposed to a page at a time.)
> 
> In the interest of gathering benchmarking data, we'd like to 
> try.  The catch
> is the number of occurrences for a multiple occurrence DS.  
> The obvious
> workaround is to base the DS on a pointer, which works great 
> up to 16 megs.
> But my result set is going to be much larger than that.  I 
> can certainly
> ALLOC more memory and use another DS, but I don't see any way 
> to guarantee
> contiguous memory, and without that I can't guarantee that 
> the result set
> will be right.
>   --buck
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> 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.
>