Temporarily disable the Indexing MFS (OpenInsight Specific)
At 16 FEB 1998 06:56:39AM Nick Stevenson wrote:
Is it possible to temporarily, programmatically, disable the Indexing MFS? We at times want to do to massive imports into tables that have indexes on them, and only want to rebuild the indexes at the end. I remember AREV has BATCH.INDEXING, but whether this enables the above I can't remember.
At 16 FEB 1998 11:38AM Carl Pates wrote:
Nick,
An Arev 2.12 system routine called Index_Toggle was documented in an issue of Revmedia which could be used to turn indexes on and off. It's still there in OI however…
Basically the syntax is:
Call Index_Toggle( FileName, Position, Action )
where:
FileName is the name of the indexed file.
Position is the MFS position in the MFS chain on the file when adding adding SI.MFS back.
Action can be one of three values:
0 - disable the indexing
1 - put indexing back on
2 - put indexing back on and rebuild
cpates@sprezzatura.com
World Leaders in all things RevSoft (Except VIP)
