Fujitsu UDS/SQL V2.5 Manual De Usuario
SSL
Placement
U929-J-Z125-9-76
169
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
Example
DDL: SET NAME IS CUSTOMER-ORDERS-PLACED
.
.
.
.
.
OWNER IS CUSTOMER.
MEMBER IS CUSTOMER-ORDER
.
.
.
.
.
SSL: RECORD NAME IS CUSTOMER-ORDER
PLACEMENT OPTIMIZATION FOR SET CUSTOMER-ORDERS-PLACED.
SET NAME IS CUSTOMER-ORDERS-PLACED
POPULATION IS 10
MODE IS POINTER-ARRAY ATTACHED TO OWNER
INDEX NAME IS SEARCH-TAB-C-ORD-PLCD
MODE IS POINTER-ARRAY ATTACHED TO OWNER
INDEX NAME IS SEARCH-TAB-C-ORD-PLCD
PLACING IS DETACHED.
In this example, UDS/SQL would arrange the records and table of the set as follows:
Figure 42: Placement of data based on the above definition
cust. 1
10-line
pointer array
pointer array
10 orders
of cust. 1
of cust. 1
10-line
SEARCH key table
SEARCH key table
cust. 2
cust. 3
10-line
ptr. array
ptr. array
10 orders
of cust. 2
of cust. 2
10-line
SEARCH key table
SEARCH key table
. . .