Index behavior and keys with system delimiters (Functions/Subroutines/Programs,General) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Index behavior and keys with system delimiters (Functions/Subroutines/Programs,General) ======

======   ======

==== Created at 20 AUG 2009 01:58PM ====




If an OpenInsight/Advanced Revelation data table contains data records with keys that contain system delimiters (@TM->@RM) in them and indexing is applied to this table the indexes can be corrupt and return incorrect results.  This longstanding issue can be resovled by applying the attached RDK.  This RDK updates F.INDEXER and BUILD.INDEX procedures to strip out any keys that have system delimiters.  If any keys with these delimiters are encountered, they are written into the SYSLISTS item RTI_INDEX_ERRORS.  These data records will remain in the table and are not deleted. They are only excluded from the indexes. This RDK may be applied to OpenInsight 8.0.x and above.



 

[[http://www.revelation.com/o4wtrs/KB_Articles/KB0264_files/idxRDK.zip|{{kb0264_1.png}} ]]