Fujitsu UDS/SQL V2.5 사용자 설명서
Schema DDL
SEARCH KEY and ORDER clause
U929-J-Z125-9-76
107
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.9 Assigning names to hash areas and tables
Names must be assigned to hash areas and tables for secondary keys and tables for
primary keys if they are to be referenced by the SSL for the following purposes:
primary keys if they are to be referenced by the SSL for the following purposes:
–
determining the physical placement of the hash areas and tables
–
preventing redundancy in tables
–
defining the type of table reorganization desired
Names are assigned to hash areas or tables for secondary keys on record type and on set
level by:
level by:
⎧CALC ⎫
SEARCH KEY IS..... USING
⎨ ⎬ NAME IS name.....
⎩INDEX⎭
Names are assigned to tables for primary keys on set level by means of:
ORDER IS SORTED INDEXED NAME IS name.....
where name specifies the name of the hash area or the table.