This section provides an example of using the format in“Correctly formatting XML data for fields and zones.” This sample accomplishes the following steps:
Creates an empty text index on an empty table.
Drops the text index. This step drops the proxy tables associated with the text index in Adaptive Server, but leaves all default directories and files in the collections directory structure for EFTS text indexes.
Modifies the style.dft file to set the universal filter.
Inserts data into the table.
Recreates the text index.
Issues select requests that isolate rows based on the XML data, using the text index.
