Usage
Net Search Extender can use UDFs or a stored procedure call to perform searches. The Net Search UDFs are similar to the functions used by Text Extender. They are called Contains and Textsearch. The stored procedure is also called Textsearch. The stored procedure is recommended for high performance when the application needs only a small subset of the data. If the stored procedure needs to retrieve a large amount of the data, it will require more memory and may not be as efficient.
Contains Function
The Contains UDF for Net Search Extender is similar to that used by Text Extender. Refer to Chapter 15 “DB2 Text Extender” or the Net Search Extender Administration Guide for a more detailed description. The Contains UDF can be added to the predicate ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
