Fujitsu UDS/SQL V2.5 Manuel D’Utilisation
SSL
Population
U929-J-Z125-9-76
141
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
0
8:
58
.5
5
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
5
When storing an owner record, UDS/SQL reserves:
–
the calculated storage space, if it is smaller than one page,
–
one page, if the calculated storage space is greater than one page.
for each table belonging to the associated set occurrence.
In the case of SYSTEM sets, UDS/SQL reserves exactly one database page for each table,
regardless of the POPULATION clause.
regardless of the POPULATION clause.
Table extensions
UDS/SQL automatically extends pointer arrays, lists, sort key tables and set SEARCH key
tables if the need arises when member records are stored. In order to avoid frequent table
extensions, the user can control table size using the following specification in the set
POPULATION clause:
tables if the need arises when member records are stored. In order to avoid frequent table
extensions, the user can control table size using the following specification in the set
POPULATION clause:
POPULATION IS integer-1 INCREASE IS integer-2
integer-2
specifies the number of table lines to be added with the first two table extensions.
Following the second extension, integer-2 * 2
n
(nïnumber of extensions) table lines are
added until there is no more space for a further table line. If data other than that belonging
to the table is contained in the page, preventing the table from being extended, a subse-
quent table extension includes the relocation of the table. In this case, UDS/SQL makes
available a page large enough to accommodate the table and its desired extension.
to the table is contained in the page, preventing the table from being extended, a subse-
quent table extension includes the relocation of the table. In this case, UDS/SQL makes
available a page large enough to accommodate the table and its desired extension.
For table extensions beyond the first table page, integer-2 no longer has any effect (see the
section
section
).
The default value for integer-2 is 1.
Storage space requirements for member records
This only applies to member records which are not included in a list. When the owner is
stored, UDS/SQL reserves space for its member records if the PLACEMENT
OPTIMIZATION clause is defined for the member record type (see the section
stored, UDS/SQL reserves space for its member records if the PLACEMENT
OPTIMIZATION clause is defined for the member record type (see the section
). In this case, UDS/SQL uses the entry in
the set occurrence population clause to calculate the storage space requirement for the
member records.
member records.