On Sun, Mar 9, 2008 at 8:39 AM, BirgittaHauser <Hauser@xxxxxxxxxxxxxxx> wrote:
> May be other DBAs fell being redundant on the iSeries, because the system
> makes a lot of work for them.
There is one important RDBMS capability that i found missing in i5/OS
DB2, and that was full text search. It is included in V6R1, though.
DB2 Text Extender adds the power of full-text retrieval to SQL queries by making use of features available in DB2 UDB for AS/400 that let you store text documents in databases.
DB2 Text Extender offers DB2 UDB for AS/400 users and application programmers a fast, versatile, and intelligent method of searching through such text documents. DB2 Text Extender's strength lies in its ability to search through many thousands of large text documents, finding not only what you directly ask for, but also word variations and synonyms.
You are not restricted to searching only in text documents stored in DB2 UDB for AS/400 databases, you can also search in text documents stored in files.
SELECT * FROMM yTextTable
WHERE version = '2'
AND DB2TX.CONTAINS (
IN SAME PARAGRAPH AS "table"
AND SYNONYM FORM OF "delete"') = 1