RE: fast search or scan for words in selected field

How about 3 fields in the customer master record - first name, last
name, middle name. Then three logicals (or SQL), use SETLL and READE.

> -------- Original Message --------
> Subject: fast search or scan for words in selected field
> From: "rpg news" <rpgnews@xxxxxxxxxx>
> Date: Fri, September 10, 2004 8:21 am
> To: MIDRANGE-L@xxxxxxxxxxxx
> 
> Hi,
> 
> We currently have customer master file which has customer company name
> field. Customer company name field is 20 long, if this field has "MY
> TEST COMPANY" description saved then we have another program which will
> make three records for this records in our custom file, first records
> with their customer number and name  will have "MY" and second record
> will have "TEST" and the third record will have "COMPANY". We have to do
> this for fast search by any description given by customers.  Our files
> are getting huge and want to know if there is another quick way to
> handel this on green screen. I thank you for your time.
> 
> Wayne
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.