Page History
Manually removing an index may be required when corruption or data loss occurs to the index portion of your data file (the so-called "bang file", called that because the filename is prefixed with an exclamation point (!). If this error occurs frequently, make sure that the Windows 2000 Service is installed and running on your system. The The Windows 2000 Service is designed specifically to reduce the possibility of these types of problems.
In this example, we will completely remove all indexes from the CUSTOMERS table in the EXAMPLES application. The The data for the EXAMPLES application is found in the DATAVOL volume (a subfolder of C:\RevSoft\OI32Bit, the folder in which the OpenInsight executables are stored). Do Do the following:
Before removing indexes manually, you need to remove SI.MFS, the MFS that controls index updates, from the CUSTOMERS table. Do Do the following:
Log into your SYSPROG application.
From the System Editor's command line, enter the following,
...
