Try OpenEdge Now
skip to main content
Programming Interfaces
Data Management : Database Access : The CONTAINS operator : Word indexing non-OpenEdge databases
 
Word indexing non-OpenEdge databases
OpenEdge DataServers do not support word indexing. To create a word index on text from a non-OpenEdge database accessed by a DataServer that does not support word indexing, you must write an ABL routine to read records from the non-OpenEdge database and copy the text into a table in an OpenEdge database.
You might define an OpenEdge table with the fields nonprog_primary_key and nonprog_text. Define a word index on nonprog_text, then load text and keys from the non-OpenEdge database into the table. Then, use the word index to find the primary keys for records that contain specific words.