RevMedia

Thanks to Michael Ruane of Phoenix Solutions Inc who pointed out that users of the Make.Index routine will be saddened to hear that as of release 2.11 direct calls are no longer necessary! The DICT.MFS logic has been enhanced to the degree that the simple act of updating dictionary records with the appropriate index flag ensures that all appropriate index parameter records are written. This even covers the %ALL.IDS% record to ensure that the new index is built.

Thus to add a Btree index, all that is required is to WRITEV 1 to field 6 of the appropriate dictionary item and then to call an INDEX.FLUSH to ensure that the index is rebuilt there and then. Similarly, to add an Relational index, all that is required is to write the FILE*FIELD*SORT_ORDER information to field 23 of the appropriate dictionary item. XREF dictionary items still need to be created to support XREFed dictionary items though!

To remove an index just reverse the process, WRITEV null to the appropriate field - the system will automatically take care of removing the index records.