Re: JDBC equivalent to RPG SETLL or CHAIN?

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