Re: More fun with native RLA on an SQL view

["James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>]

CRPence wrote:
>    Do "going forward" and "going backward" mean to imply the use of 
> the expected /sequential access method/ [i.e. retrieve previous or 
> next] versus the unexpected /direct access method/ [i.e. retrieve by 
> rrn; for other than *START or *END] for row retrieval?

Hmmmmm......

Going to another ILE RPG test program, *START doesn't work for CHAIN, 
but it works just fine for SETLL.

SETLL with *START gets me to a "good" record.
SETLL with 1 gets me to an "excluded" record.
SETLL with 0 gets me no record at all.
SETGT with 0 gets me to an "excluded" record.

Interesting, since I'm just about certain that MI is calling the same 
thing an RPG SETLL calls, rather than what an RPG CHAIN calls.

--
JHHL