Fujitsu UDS/SQL V2.5 사용자 설명서
Schema DDL
Types of access
U929-J-Z125-9-76
103
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
4.7.5
Determining set occurrence selection
SET OCCURRENCE SELECTION IS THRU
⎧CURRENT OF SET ⎫
⎧item-name ⎫
MULOCATION MODE OF OWNER[ ALIAS FOR ⎨ ⎬ IS identifier-2]...MU
⎩ ⎩identifier-1⎭ ⎭
When accessing records via sets, it is first necessary to select the desired set occurrences.
Two selection options are available:
SET OCCURRENCE SELECTION IS THRU CURRENT OF SET
In this case, the record last referenced within a set (CRS) identifies the set occurrence.
SET OCCURRENCE SELECTION IS THRU LOCATION MODE OF OWNER
[ALIAS FOR item-name / identifier-1 IS identifier-2]...
[ALIAS FOR item-name / identifier-1 IS identifier-2]...
⎧item-name ⎫
[ALIAS FOR
⎨ ⎬ IS identifier-2]...
⎩identifier-1⎭
This option requires you to have defined a unique primary key for the owner record type with
one of the following clauses:
one of the following clauses:
–
LOCATION MODE IS DIRECT or LOCATION MODE IS DIRECT-LONG
–
LOCATION MODE IS CALC..... DUPLICATES ARE NOT ALLOWED
This key is either the database key or a CALC key.
UDS/SQL can use this option either to read a record from a set occurrence (see the manual
“
“
”, FIND 7) or to insert a new record into a set occurrence (see
STORE and MODIFY in the “
” manual). All the programmer has to
do is provide UDS/SQL with the key value uniquely identifying the owner record of the set
occurrence. UDS/SQL will automatically select the set occurrence on owner record type
level using direct access via the database key or the hash routine, and make the selected
owner record the CRS.
occurrence. UDS/SQL will automatically select the set occurrence on owner record type
level using direct access via the database key or the hash routine, and make the selected
owner record the CRS.