Re: fast search or scan for words in selected field

oh, wow.  Would performance be acceptable?  This is a major improvement over
building a key file. 
 
---------------------------------
Booth Martin
http://www.martinvt.com
---------------------------------
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: 09/10/04 10:14:38
To: Midrange Systems Technical Discussion
Subject: 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