Once any table is enabled for text extender search, search functionality is provided using UDFs. These user defined functions (automatically created once the database is enabled for text search) can be freely used in any sql like other udfs/built-in functions and are feature rich. Ex.
select * from table where contains(column,"Search pattern")=1 We don't use "Peregrine". It is just the DB2 Text Extender that we use. -----Original Message----- From: Likar, Lida [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 1:10 PM To: 'Vilas, Ajith (USPC.PCT.Hopewell)'; '[EMAIL PROTECTED]' Subject: RE: [DB2EUG] Peregrine Service Center on UDB/Sun platform Thank you for the information. It is my understanding that the DB2 Text Extender is called thru a stored procedure. How did you implement the stored procedure call with Peregrine? Lida Likar Open Systems DBA/Inovant a Visa Solution Company -----Original Message----- From: Vilas, Ajith (USPC.PCT.Hopewell) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 6:35 AM To: 'Likar, Lida'; '[EMAIL PROTECTED]' Subject: RE: [DB2EUG] Peregrine Service Center on UDB/Sun platform We have implemented a fast and efficient "case in-sensitive" search using DB2 Extender product (Text/Text Information/Net Search). It comes with DB2 at no extra cost ;-) Regards, Ajith -----Original Message----- From: Likar, Lida [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 8:37 PM To: '[EMAIL PROTECTED]' Subject: [DB2EUG] Peregrine Service Center on UDB/Sun platform Did anybody successfully implemented Peregrine's Service Center 4.0 with UDB 7.2 /Unix ? We need to implement "case in-sensitive" search capability. Any help or tip will be greatly appreciated. Lida Likar Open Systems DBA/Inovant a Visa Solution Company - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
