Fujitsu UDS/SQL V2.5 Manuel D’Utilisation
Schema DDL
Types of access
U929-J-Z125-9-76
99
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
9:
30
.2
3
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
4
Figure 25: Sorting a set occurrence according to the key ART-NAME
ORDER IS SORTED BY DATABASE-KEY
UDS/SQL sorts the member records of the set occurrence in ascending order according to
the values of the database key. In this case, the database key is also referred to as primary
key of the set.
the values of the database key. In this case, the database key is also referred to as primary
key of the set.
The values of the database key can be defined by the user (see the
) or left to
UDS/SQL.
If, by means of SSL, a storage mode is established which causes UDS/SQL to set up a table
in order to sort a set occurrence (see
in order to sort a set occurrence (see
; pointer array, list), UDS/SQL also uses the
table as direct access path.
In this case, the above clause must be supplemented by INDEXED, which results in the
creation of a multi-level table (see
In this case, the above clause must be supplemented by INDEXED, which results in the
creation of a multi-level table (see
Water
ARTICLE
Cocoa
Lemonade
ARTICLES
-
AVAILABLE
SUPPLIER
Moore
Beer