Kbase P104149: What Metaschema fields are involved in table and database CRC calculations?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/03/2008 |
|
Status: Verified
GOAL:
What Metaschema fields are involved in table and database CRC calculations?
GOAL:
What parts of the schema definition affect table and index CRC values ?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
All Progress table and database CRC calculations involve the following fields from the _File, _Field, _Index and _Index-Field Metaschema tables:
1. The _File Metaschema table:
_File-Name
_DB-lang
2. The _Field Metaschema table:
_Field-Name
_Data-Type
_dtype
_sys-field
_field-rpos
_Decimals
_Order
_Extent
_Fld-stdtype
_Fld-stlen
_Fld-stoff
_Fld-case
A change to any of these fields automatically changes the CRC value of a table. The resulting CRC is stored in the _CRC field of the _File record for the table.
3. The _Index Metaschema table:
_Index-Name
_Unique
_num-comp
4. The _Index-Field Metaschema table:
_Field-Name
_Ascending
_Abbreviate
_Unsorted
A change to any of these fields automatically changes the CRC value of the index. The resulting CRC is stored in the _Idx-CRC field of the _Index record for the index.