Filter
Top Products
Calculation formulas SSL
178 U929-J-Z125-9-76
Calculation formulas for a database with a 4000 or 8096-byte page length
Number of records
in the data page
page length-20
record length
1
+12
1
The record length is the length of a record according to the schema DDL plus the length of its pointers (see
page 224, SCD)
in the direct CALC page
page length-30
record length+key length+22
Number of entries in the indirect CALC page
page length-30
key length+10
Number of table
entries per page in a:
List
page length-50
record length+12
pointer array
2
sort key table
3
SEARCH key table
(TYPE IS REPEATED-KEY)
2
⎧LAST ⎫
FIRST
NEXT
If ORDER IS ⎨ ⎬ key length = 0
PRIOR
IMMATERIAL
⎩SORTED INDEXED BY DATABASE-KEY⎭
3
If ORDER IS SORTED INDEXED BY DATABASE-KEY key length = 0
page length-50
key length+10
Table 11: Calculation formulas for a database with a 4000 or 8096-byte page length