Is there any way to do a full text indexing in DB2/400? I have a table that is mainly text and I want to query it the same way a knowledge base does.
DB2 UDB Text Extenders, which are a part of the DB2 UDB for Extenders LPP introduced in V5R1, provide the ability to perform advanced text searches. Special index types are used by the DB2 Text Extenders to enable these advanced text searches to run quickly.
You can find an online education module on the DB2 UDB Extenders for iSeries product here.
The manual for DB2 Text Extenders can be found here.
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.
Dig Deeper on iSeries SQL commands and statements
Related Q&A from Kent Milligan
Create a host variable of the where in statement on the fly with dynamic SQL. Continue Reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading