Fujitsu UDS/SQL V2.5 用户手册
Structure of records and tables
Table structure
U929-J-Z125-9-76
225
D
ok
us
c
h
abl
on
en
1
9x
24 V
e
rs
ion
7
.3
us
f
ü
r F
ram
eM
ak
er
V
7
.x
v
o
m
1
4.
02
.2
00
7
©
c
o
gni
tas
Gm
b
H
20
01-
20
07
24
. Ok
tobe
r 20
07
S
ta
nd
1
2:
03
.1
4
P
fa
d:
G
:\
v
og
t\
fs
c
\ud
s
\M
anu
al
e
\e
n\
ud
s
e
nt
_e\
u
ds
ent
.k
0
8
Explanation of
:
The length of the entries for the record sequence number (RSQ) and page index depend
on the page length that was defined for the database:
on the page length that was defined for the database:
–
In tables of a database with a 2048-byte page length, the RSQ entry is 3 bytes long,
and the page index entry is 8 bytes.
and the page index entry is 8 bytes.
–
In tables of a database with a 4000-byte or 8096-byte page length, the RSQ entry is
6 bytes long, and the page index entry is 12 bytes.
6 bytes long, and the page index entry is 12 bytes.
Pointer arrays, lists, sort key tables and standard SEARCH key tables are structured
according to the principle shown in
according to the principle shown in
. (The representation of the table line does not
apply to duplicates tables.) They are always stored in data pages. If a table does not fill a
page completely, the remaining space can be used for records or further tables. The table
headers contain the space reservations specified in the POPULATION clauses. This repre-
sents the third level of the three-level UDS/SQL Free Place Administration facility.
Furthermore, the table header contains pointers to other table parts if the table exceeds one
page and a pointer to the next higher table level if the page belongs to a lower level. Two
further indicators show the table level of the page itself and the type of the table.
page completely, the remaining space can be used for records or further tables. The table
headers contain the space reservations specified in the POPULATION clauses. This repre-
sents the third level of the three-level UDS/SQL Free Place Administration facility.
Furthermore, the table header contains pointers to other table parts if the table exceeds one
page and a pointer to the next higher table level if the page belongs to a lower level. Two
further indicators show the table level of the page itself and the type of the table.
1)
follows the last table line in the case of lists.
2)
bit 2
7
=1: list
2
6
=1: multi-level table
2
5
=1: table ATTACHED TO OWNER
2
4
=1: duplicates table
3)
does not apply to duplicates tables (see
4)
applies to the highest table page of a multi-level table or to the first table page of a
single-level table only.
single-level table only.