Re: fast search or scan for words in selected field

I have found embedded sql inside rpg to be great for this kind of searching.
You no longer need the split file.
I can select all the records with TEST anywhere in the name
with a SELECT statement:
SELECT CUSID from CUST where name like %TEST%
and it will return a list of customer numbers (which you can put in an array
or data structure to process).
There have been samples previously posted, may be sample in IBM's Info
Center,
or send note offline. There are considerations as to how your files ares
indexed.
jim
----- Original Message ----- 
From: "rpg news" <rpgnews@xxxxxxxxxx>
To: <MIDRANGE-L@xxxxxxxxxxxx>
Sent: Friday, September 10, 2004 8:21 AM
Subject: fast search or scan for words in selected field


> 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.
>
>