Ask the Expert

Full text indexing in DB2/400

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.

=================================='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.

This was first published in October 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: