Please be aware that MS fix KB2698365 will stop the indexing server working. Tests show it is OK but when searching you will receive an error “Unable to execute text search” Remove this item from Windows and the search will continue to work.

Configure Index Server (W2K)

Access indexing server through computer management/services and applications /indexing service / system/directories. Create a new directory (Right click and select new) Name the folder PersonCV. Set priority to Instant and low load. Start service.

Document folder

Create folder for docs to be indexed in root of a drive other than the one used by DB, call it CVTEXT. Once the file is created create a TXT document inside and enter some words. Close and save.

Daemon

Install Daemon.exe on the route of drive, either Ntserver or Windows 2000/XP version. Run testbed.exe, then login with the DB name. Select OK ignoring search definition. Enter the following details:

ID: PersonCV Catalog: System Scope: Directory: C:\CVText Command: (directory path of Daemon.exe) C:\winnt\iqxsdbDaemon5.exe DSN: (DSN Name of IQX DB entry usually IQX) UID: Pears

Now enter text contained in the saved text file into the Query field and run the query.

SQL Script

Login to the DB using SQLTool or ISQL. Run script. A typical trigger is below:

CREATE TRIGGER pears.PersonCVUpdate AFTER UPDATE OF CvText
ORDER 2 ON pears.Person
REFERENCING OLD AS Old_Name NEW AS New_Name
FOR each ROW
BEGIN
  CALL IXTextWrite('PersonCV','CV',old_name.PersonID,new_name.CVText)
END

Pears Dictionary

Login to DB using SQLTool Go to dictionary Select People and CV Change the following: Type: Indexed Text Database Item: PersonCV Complex Expression: Person.PersonID in (<EXPRESSION>)