Fujitsu UDS/SQL V2.5 用户手册
Structure of records and tables
Record structure
U929-J-Z125-9-76
223
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
1 Database key value + PPP of the first member record ... 8/12 bytes
2 Database key value + PPP of the last member record ... 8/12 bytes
3 Database key value + PPP of the following record ... 8/12 bytes
4 Database key value + PPP of the preceding record ... 8/12 bytes
5 RSQ of the owner
... 3/6 bytes
6 PPP of the owner
... 4 bytes
7 Act-key of the beginning of the table
... 4 bytes
8 Indicator for SYSTEM set
... 1 byte
This byte contains X'00' if the member record belongs to the set
and X'FF' if it is not part of the set.
In the case of “MODE IS CHAIN”, the byte is redefined as shown in
point 3 (see above).
and X'FF' if it is not part of the set.
In the case of “MODE IS CHAIN”, the byte is redefined as shown in
point 3 (see above).
MODE IS
RECORD
TYPE
TYPE
OWNER
IS
SYSTEM
IS
SYSTEM
ORDER
IS
LAST
IS
LAST
LINKED
TO
PRIOR
TO
PRIOR
MEMBER
LINKED
LINKED
PHYSI-
CAL
LINK
CAL
LINK
SCD
length
in
bytes
length
in
bytes
SCD
content
content
CHAIN
Owner
Y/N
N
Y
Y/N
N
N
N
Y
-
-
8/12
16/24
16/24
16/24
1
1,2
1,2
1,2
1,2
Member
Y
N
Y
Y
-
-
8/12
16/24
3
3,4
3,4
N
N
N
N
Y
Y
Y
N
Y
N
Y
-
11/18
15/22
19/30
23/34
15/22
19/30
23/34
3,5
3,5,6
3,4,5
3,4,5,6
3,5,6
3,4,5
3,4,5,6
POINTER-
ARRAY
ARRAY
or
LIST
Owner
Y
-
-
-
0
-
N
-
-
N
Y
0
4
4
7
Member
Y
-
-
-
1
8
N
-
N
Y
Y
-
3/6
7/10
5
5,6
5,6
Table 20: Overview of the possible SCD combinations per set