Kbase P38130: How to determine the number of records per block via ABL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/01/2011 |
|
Status: Verified
GOAL:
How to determine the number of records per blockv ia ABL
GOAL:
Can I find the number of records per block using a VST (Virtual System Table).
GOAL:
How to obtain the number of records per block using a VST (Virtual System Table).
GOAL:
How to determine the number of records per block within a storage area using a VST (Virtual System Table).
GOAL:
How to determine the # of records per block within a storage area using a VST (Virtual System Table).
GOAL:
How to determine records/block for a storage area using a VST (Virtual System Table).
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
FIX:
There is no VST (Virtual System Table) that stores the number of records per block for any given storage area. However, this information can be obtained by using the following field from _Area system (schema) table: _Area-recbits.
The _Area?recbits field contains the number of bits used to represent the position of the record within the database block. To obtain the number of records per block, simply increase the _Area-recbits value by the power two (2).
The following is a 4GL program that illustrates how to obtain the number of records per block for a database:
FOR EACH _area WHERE _area._area-num > 5 NO-LOCK:
DISPLAY _area._area-name _area._area-recbits EXP(2,_area._area-recbits).
END.