In the Knowledge Base Howto for manually removing indexes, the first step is to log on to the SYSPROG and attach the REVMEDIA. Why do you need to be in SYSPROG? Can it be done from within the application? Is it possible to program these manual steps? If anyone can help.

Thanks

Richard

For security reasons non-Sysprog accounts normally cannot attach or alias the REVMEDIA file. What good would a security MFS do if anybody could edit the REVMEDIA file and remove the MFS?

Yes, you can write programs to run in Sysprog to automate the task. Everything you need to update/modify is detailed in the knowledge base article.

I was not wanting to change the security. I was just wanting to be able to repair damaged indexes from within the application.

Nobody said anything about you wanting to change security.

Attaching the REVMEDIA files is restricted to the SYSPROG account for security reasons.

Data intregrity can also be destroyed if someonr changes other settings in the REVMEDIA file items such as the DOS file name. Again, this is why access to the REVMEDIA files is restricted to SYSPROG.

The assumption is that if you have access to SYSPROG than you should know what you are doing.

If the indexes are hosed, document the settings, delete the !file and then removing indexing via the database manager. 99% of the time this removes all the dictionary items settings as you'd do manually.

Even if you have a number of files to fix, it's not difficult to log into SYSPROG write a procedure there to do the attaches and remove SI.MFS from the file descriptors, then log into the user account and write a procedure to make the changes to the dictionaries. All you need to do is change to file and volume names in loop. Fields that are indexed can be determined from the %FIELDS% record in the dictionary or the *INDEXES record in the !file.

There are ways to attach the REVMEDIA files from user accounts but dicussion of these in a public forum would not be prudent. Contact tech support for more information in that direction.

Where else is indexing inforamtion stored? Other than the REVMEDIA and DICT. files and !files.

Thanks

View this thread on the forum...