RE: fast search or scan for words in selected field

A problem with that is that the company name could even be "Christmas Store
with Reindeer, Elves, Mrs Claus, and Mister James Boswell Claus".

My own reaction is "Define Huge".  Even if the search file is huge, the
Customer File must be even more huge.   I am wondering if the real problem
is that the search file needs reorganizing or purging.  Keying on words like
"My" seems unlikely to narrow the search in a meaningful way.
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: 09/10/04 09:48:46
To: Midrange Systems Technical Discussion
Subject: 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
>
>