James,

There is no "key" in a result set, plain and simple. Your only solution
would be to download the entire result set into some container that
provided "keyed" access of some sort.

IMHO, you'd be better served by moving away from the idea of "position to".
Instead, think "subset to" or "filter".

Charles


On Tue, Jul 2, 2013 at 7:33 PM, James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

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
tool.


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.

--
JHHL
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.