Re: Embedded SQL For Screen Load

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 12/15/2016 04:56:23
PM:

My advice...

Don't do it. SQL doesn't really support "Position To", instead it's

more

"Search/Subset By"

Really? What about the following?

where db_column >= :search

Lot's of posts over the years detailing the hoops needed in SQL to do

a

position to (and provide the exact functionality you have now). Not

really

worth the effort IMO.

I don't see any hoops in doing the example above. The only challenge is

if

there's nothing that matches and you want to display the previous record

as well as those that are greater than the search criteria.

Not a problem if you're willing to use a scrollable cursor. In
this case, if the first fetch does not have a key equal to the position-to
value, then you just have to reposition the cursor to -1 relative to the
row fetched. That enables you to fetch the row previous to the first
non-matching key.

Sincerely,

Dave Clark