Re: Full-text searching

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

The text extenders do add text search capabilities to SQL. From the PDF -

"DB2 Text Extender adds the power of full-text retrieval to SQL queries"

PDF can be found at

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/books/sh126720.pdf


There is also an HTTP text search component, iSeries Webserver Search 
Engine, information at

http://www-03.ibm.com/systems/i/software/http/services/search.html

It is only for searching for a web site, I think, but not sure - haven't 
used it. It handles only text files and html files.


And there is a new thing that I saw at the DB2/RPG Summit called 
OmniFind that can search many types of documents - Word, etc. Not just 
text or html. Kent Milligan has a white paper on it with this quote-

"OmniFind Text Search Server for DB2 for i delivers the common DB2 
Family text-search technology to the IBM i developer community. It 
requires a minimum operating-system release level of IBM i 6.1. OmniFind 
also replaces the DB2 Text Extender product that is available on 
previous IBM i releases. Unlike its predecessor product, OmniFind is a 
no-charge product. Currently, the product must be ordered and installed 
separately. The OmniFind Text Search Server product identification 
number is 5733-OMF."

PDF available at

http://www-03.ibm.com/servers/enable/site/education/wp/1fe46/1fe46.pdf

It has google-like weighted search capabilities - very cool stuff. And 
did you notice, it is free? This adds functions to SQL, just like Text 
Extenders did/does.

HTH
Vern

rob@xxxxxxxxx wrote:
> Talking out of complete ignorance here, truly, but does DB2 UDB Text 
> Extenders mean anything?  Out of curiosity I tried to search for that but 
> wasn't having much luck.
>
>
> Rob Berendt
>