Progress
Database Design
Guide


Word Indexing and Non-Progress Databases

Word indexing is a Progress database feature that is not supported by other databases; however, you can simulate it using this method. To create a word index on text from a non-Progress database, you must write a Progress 4GL routine to read records from the non-Progress database and copy the text into a table in a Progress database.

You might define a table with the fields foreign primary key and foreign text. Define a word index on foreign_text and load text and keys from the non-Progress database into the table. You can then use the word index to find the primary keys for records that contain specific words.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095