RE: RPG400-L Digest, Vol 15, Issue 563

Hi Bill

If you use %LOOKUPGE it'll find exact matches if there are any or the next entry if there is one.

Cheers
Jonathan


-----Original Message-----

------------------------------

message: 4
date: Wed, 14 Dec 2016 12:42:57 -0500
from: Bill Howie <blhowie66@xxxxxxxxx>
subject: Re: Subfile question - Position To functionality

Jon,

Here's my definition of my array:

loc s 8 dim(1600) ascend

Here's my lookup:

eval n = %lookupgt(scpos:loc)

The "SCPOS" field, in the scenario I'm looking at, would have be like this:
"OVbbbbbb" where the b's are blanks. I would want to position my subfile to records which could have just "OV" in them, or "OVERFLOW", or "OVER-1AB", etc. So I'm basically entering a partial value in my search field and I want to be able to find the array elements from there on. If LOOKUPGT won't work I'll just go to creating a temporary file to hold my locations. If I do that, SETLL would work in this scenario, right? We are at V5R4 FYI.

Bill




Proud partner of The Ageas Bowl and the Ageas Salisbury International Arts Festival.

Registered Address: Ageas House, Hampshire Corporate Park, Templars Way, Eastleigh, Hampshire, SO53 3YA Registered Number: 354568 England

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority

This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.