Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming


Chapter 5. Searching with Text Extender UDFs

Text Extender provides SQL functions that enable you to include text search subqueries in SQL queries. These functions are provided in addition to those normally available in SQL. They are known in DB2 as user-defined functions (UDFs).

Refer to Chapter 9, UDTs and UDFs for a description of the UDFs' syntax.

Before searching, read Types of index, and also use GET INDEX SETTINGS to find out which index type is associated with the text you are searching in. A search can produce different results according to the index type.

The index type assumed in the examples in this chapter is linguistic.

This chapter describes:


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]