Fujitsu UDS/SQL V2.5 用户手册
Reference section
Schema DDL
U929-J-Z125-9-76
245
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
⎧LAST ⎫
FIRST
NEXT
PRIOR
ORDER IS
⎨ ⎬
IMMATERIAL
SORTED[ INDEXED[ NAME IS name]]
⎧DATABASE-KEY ⎫
BY ⎨ ⎬
⎩ ⎩DEFINED KEYS DUPLICATES ARE[ NOT] ALLOWED⎭⎭
This clause is used to define
–
the sequence of the records within the set occurrences for sequential processing.
–
an additional direct access path via the primary key.
⎧record-name⎫
OWNER IS
⎨ ⎬.
⎩SYSTEM ⎭
A record type defined by the user or a symbolic record type SYSTEM is declared owner
record type of the set.
record type of the set.
⎧MANDATORY⎫ ⎧AUTOMATIC⎫
MEMBER IS record-name
⎨ ⎬ ⎨ ⎬
⎩OPTIONAL ⎭ ⎩MANUAL ⎭
A description of the member record type is not required for dynamic sets.
In all other cases, the above clause is used to declare a record type member record type
and to specify the type of membership of the member records in the set.
In all other cases, the above clause is used to declare a record type member record type
and to specify the type of membership of the member records in the set.