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 length1 +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 DA TABASE-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