Fujitsu UDS/SQL V2.5 用户手册
Reference section
SSL
U929-J-Z125-9-76
257
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
18
. Ok
tobe
r 20
07
S
ta
nd
1
1:
29
.5
2
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
9
[INDEX NAME IS name
⎧ATTACHED TO OWNER ⎫
[PLACING IS
⎨ ⎬]
⎩DETACHED[ WITHIN realm-name]⎭
⎧DATABASE-KEY-LIST ⎫
[TYPE IS
⎨REPEATED-KEY ⎬]]...
⎩ [DYNAMIC REORGANIZATION SPANS integer PAGES]⎭
name
must be the name of a table or of a hash area specified in the Schema DDL.
ATTACHED
may be specified only if the set is not a SYSTEM set.
realm-name
must not denote a temporary realm. If this entry is omitted, UDS/SQL selects the
default value as indicated on
default value as indicated on
integer
must be an integer between 1 and 20. Default value: 2
If a table of this set has been specified in the Schema DDL, this table can be referenced
here in order to define its placement, type and extent of reorganization.
If a SEARCH key has been defined for storage in a hash area, the realm which is to contain
this hash area can be specified here.
here in order to define its placement, type and extent of reorganization.
If a SEARCH key has been defined for storage in a hash area, the realm which is to contain
this hash area can be specified here.
Default values
–
for PLACING: DETACHED
–
for TYPE: REPEATED-KEY
MEMBER IS PHYSICALLY LINKED TO OWNER
This clause is used to include an additional pointer to its owner in each member record of
the set. The SCD of a member record also contains the PPP of the associated owner
record.
the set. The SCD of a member record also contains the PPP of the associated owner
record.