Download to a Microsoft Platform

• dcQsm2Locale.dll
• dcQsm2Oledb.dll
• indexer.exe
• qsm2.exe

Optionally also download:

• sgmltoxml.exe
  • sp134.dll
• call_oldeb.exe
• comments.exe

Register the dll's

/system32/regsvr32.exe dcQsm2Locale.dll
/system32/regsvr32.exe dcQsm2Oledb.dll

Edit the registry

Create the directory in which database catalogs are to be stored.
Set the value of HKEY_LOCAL_MACHINE/SOFTWARE/Dealers Choice Software/Catalogs to the name of this directory.
This can be done by issuing the command:

regedit

Index the desired XML texts

The source texts must conform to XML. Here is a sample command that reads the xml text file xml92.xml and produces the index xml92.sql.

indexer.exe -i xml92.xml -f -m 50k -m1mb -m 14mb -w verbose -o xml92.qsm

Reference the indexed text

$ create catalog catalog1 in 'catalog1.qsm';

This will create a catalog file named catalog1.qsm having the logical name catalog1. It will also create a shortcut to this named catalog file in the directory sthat is to contain references to all database catalogs. Other names may be employed at this step if desired.

Set the default database catalog to this new catalog. For example:

$ set catalog 'catalog1';

Create the desired schema or schema's to contain the reference(s) to the externally indexed texts. For example:

$ create schema texts;

Set the default schema to the desired schema. For example:

$ set schema texts;

Create the internal reference within the database schema to the externally indexed text. This involves specifying an internal table name for the text, a column name to associate with this table, and the location of this external text. Avoid using relative path names when specifying this external text. For example:

$ create external table xml92(xml92 text) in "/xml92.qsm";

Query the indexed text

Issue queries against the indexed text to verify that it can be accessed. For example:

$ select * from xml92;

Explore further

See also:

Other supporting documentation