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
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output ...continue reading
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.