On 7/2/13 4:10 PM, Dan Kimmel wrote:
But the point is that I could use that long, narrow result set of
just the index to find the start point for a short, broad result
set, when scrolling ?>backwards through the file, and I could
reasonably search the long, narrow result set to find the ordinal
starting position when repositioning by key.

But why would you want to? That's work you want the database engine
to do for you. It is smart. It has optimizers. You are trying to
build your own index from an index. Don't work so hard. Use the

That's just IT!

So far as I have been able to determine, there IS NO TOOL in JDBC for randomly jumping to a key value within a result set, nor for scrolling outside of a result set!

My understanding is that if I open a result set starting at a specified key value, somewhere in the middle of a file, JDBC has no way of jumping to a record that's some specified number of records before the beginning of that result set, and likewise, if I open a result set of the entire file, JDBC has no way of jumping to a specific key value within the result set.

If I'm mistaken on this, somebody please tell me.

The goal here is not to re-implement native RLA for DB2/400 (that would be the most profound waste of time in history); it's to get RLA-like access to other databases.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.