Fujitsu UDS/SQL V2.5 Manuel D’Utilisation
Schema DDL
Types of access
U929-J-Z125-9-76
101
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
Example
RECORD NAME IS SUPPLIER
.
.
.
.
.
.
RECORD NAME IS ARTICLE
.
.
.
01 ARTICLE-NAME PICTURE IS X(30).
.
.
.
01 ARTICLE-NAME PICTURE IS X(30).
SET NAME IS ARTICLES-AVAILABLE
ORDER IS SORTED INDEXED BY DEFINED KEYS.....
OWNER IS SUPPLIER
MEMBER IS ARTICLE.....
ASCENDING KEY IS ARTICLE-NAME
.
.
.
ORDER IS SORTED INDEXED BY DEFINED KEYS.....
OWNER IS SUPPLIER
MEMBER IS ARTICLE.....
ASCENDING KEY IS ARTICLE-NAME
.
.
.
ORDER IS SORTED INDEXED BY DATABASE-KEY
). It also sets up a multi-level table for
each set occurrence of the set. The table represents a unique reference between database
key value and physical address for each record belonging to the set occurrence. UDS/SQL
makes use of this access path when inserting a record in or deleting a record from the set
occurrence and in sequential reading, but not for direct accesses.
key value and physical address for each record belonging to the set occurrence. UDS/SQL
makes use of this access path when inserting a record in or deleting a record from the set
occurrence and in sequential reading, but not for direct accesses.