RE: fast search or scan for words in selected field

RTFM
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/db2/rbafzmst02.htm

And you might be better off making a file of the soundex of the search 
words versus the search words themselves.

You could either rebuild the search file periodically, or put a trigger on 
the master to update the search file if the customer name changed.

Or do both.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Booth Martin" <booth@xxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/10/2004 12:46 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: fast search or scan for words in selected field






Well, how about this scenario then?  Would this be a successful 
alternative?
 Could a file of the search words be made, as is presently being done? 
Then
use SQL to search that base?  An advantage of SQl then would be to allow
searches on matching two or more of the keywords? 



But the discussions on Soundex, etc. seems like a real winner though. 
Where
would we learn more about that? 

 

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

Booth Martin

http://www.martinvt.com

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

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

 

From: Midrange Systems Technical Discussion

Date: 09/10/04 12:34:46

To: Midrange Systems Technical Discussion

Subject: RE: fast search or scan for words in selected field

 

I'm with Joe on this one.  I can't see how indices would help with

substring searches.  Then again, just because I can't comprehend it

doesn't mean it wouldn't.

 

Rob Berendt

--

Group Dekko Services, LLC

Dept 01.073

PO Box 2000

Dock 108

6928N 400E

Kendallville, IN 46755

http://www.dekko.com
--
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.