The following table lists the metaschema fields that are involved in each CRC calculation.

Table 1. Metaschema fields in CRC calculation
Metaschema table
_File _Field _Index _Index–Field 
_File-Name
_DB-lang
 
_Field-Name
_Data-Type
_dtype
_sys-field
_field-rpos
_Decimals
_Order
_Extent
_Fld-stdtype
_Fld-stlen
_Fld-stoff
_Fld-case
 
_Index-Name
_Unique
_num-comp
 
_Field-Name
_Ascending
_Abbreviate
_Unsorted

Notes

  • The _Fld-stlen is not involved in the CRC calculation for BLOB and CLOB fields.
  • The _Field–Name for index fields is referenced in the _Field table using _Field–recid in _Index–Field.
  • A value of Unknown (?) or 0 in any integer field in the above table results in the same CRC value.
  • This list is for informational purposes only. For CRC checking, only _File._CRC needs to be checked.