SQL Question

I want to do an SQL in a java program (JDBC).  It's something I'd run once a 
month, but I know it will generate a lot of records in the record set.  If I 
just did the query in one shot, I'd probably freeze my computer due to 
insufficient memory.

Is there a way to just bring down 1000 or so records at a time with each  
repeated call of the SQL getting the next 1000 and etc until I hit the end of 
what would have been one big result set?

The method that lets you do this, is it efficient for the backend dataase 
(iSeries), or does it actually run the whole query each time, but just return 
the 1000 records you need for that call?

Any advice?

Thanks,

Larry

_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com