The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 Text Search, Part 1: Full text search

Prashant Shettar (pshettar@in.ibm.com), System Software Engineer, IBM

Prashant Shettar is a Systems Software Engineer at IBM’s Information Management Group (part of IBM Software Group) in Bangalore, India.

Marion Behnen (mbehnen@us.ibm.com), DB2 Text Search Development, IBM

Marion Behnen is a Senior Software Engineer within the IBM Software Group and works as a technical lead for full-text search in DB2. She has more than 20 years of experience with database application development, business reporting, data warehousing, and business process integration. Prior to joining IBM, she was involved with many aspects of business process and data integration, in particular for the manufacturing industry.

Shantanu Mundkur (mundkur@us.ibm.com), DB2 Text Search Development, IBM

Shantanu Mundkur is an Advisory Software Engineer at IBM's Silicon Valley Laboratory. He is part of the IBM DB2 for Linux, UNIX and, Windows development team and works in the area of full-text search. He has a broad range of software product development experience, and has designed and implemented features for various database servers including DB2 and Informix.

Summary: DB2 Text Search enables an IBM DB2 for Linux, UNIX, and Windows database user to create applications with full text-search capabilities by embedding full text-search clauses in SQL and XQuery statements. In this tutorial, you'll set up a database to support text search, and walk through a scenario to get some experience for setting up your own text searches.

Note: This tutorial has been updated to better present examples and code commands to help prevent users less familiar with DB2 from encountering problems.

View more content in this series

Date: 15 Apr 2010 (Published 16 Oct 2008)
Level: Introductory
PDF: A4 and Letter (250 KB | 15 pages)Get Adobe® Reader®

Activity: 51407 views
Comments: