date: Wed, 13 Aug 2008 12:23:45 -0500
from: CRPence <>
subject: Re: Returning Record Sets from SQLRPGLE Web
So the solution for a case where IDcol is not the first
achieved by the *or* tests that were added in the example
beyond adding the selection of IDcol>savedIDcol to get
the /next page/
of data; i.e. the query requires the additional selection
with OR logic
against each of the other keys. That is what I would
expect. I had
mistakenly thought the post about adding an identity column
that somehow the IDcol could by itself solve the paging
that would only be true for otherwise unordered sets.
FWiW: If that was explained in the link given in an
earlier post in
this thread, I would not know, as the link was to _pay
content_ [best I
can tell, from my results in visiting the link].
I wonder though, what would all of the overhead of an
that a RRN() could not, for the same scenario? The
relative row number
is a similarly arbitrary value, as compared to an identity.
Walden H. Leverich wrote: