Rebuild all indexes in a file (AREV Specific)
At 19 FEB 1998 11:24:53PM Joe Wesner wrote:
I recently wanted to rebuild all indexes in a certain file which was the shop order file. There are many indexes on this file including relational indexes. When I executed it seemed to work fine but then I received a break error. If I recall correctly the program was buildindxsub or something like that. I know that the Shop Order file has about 35,000 records. I tried just updating one individual relational index and it broke with the same error. I had to go back to a backup because it took the relational index out but did not replace it with the correct values. I am using AREV 3.0 and on Novell 3.11. I have another question which caused me to rebuild the index. Any suggestions…
At 20 FEB 1998 08:59AM Aaron Kaplan wrote:
ARev 3.0 wasn't the greatest of all releases. You might want to consider moving to 3.03 which was stabler. 3.12 would be even better.
Relational wise, you might want to try and fudge the rebuild. Build everything else. Set up the relationals but don't update it. Clear the rebuild flag from the !file. Then, write a program which will read in each related record, delete it, then write it back out. This should cause the index to update itself one at a time and avoid the error. You might have to flush indexes after each write, depending on what other indexes are on the source file. Just clearing the source field, writing the record and adding it back might be better since that won't affect the other indexes and should still have the desired effects.
apk@sprezzatura.com
