Fujitsu UDS/SQL V2.5 用户手册
Reference section
Schema DDL
U929-J-Z125-9-76
239
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
A maximum of 253 record types may be defined in a database with a page length
of 2048 bytes, and
a maximum of 32 766 record types may be defined in databases with a page length
of 4000 or 8096 bytes.
a maximum of 32 766 record types may be defined in databases with a page length
of 4000 or 8096 bytes.
The individual clauses of the record entry are explained below.
RECORD NAME IS record-name
A name is assigned to a record type.
⎧ ⎧ ⎧IN⎫ ⎫⎫
⎧DIRECT ⎫
item-name-1 ⎨ ⎬ record-name
⎨
⎬ ⎨ ⎩OF⎭ ⎬
⎩DIRECT-LONG⎭
[LOCATION MODE IS
⎨ ⎩identifier ⎭⎬]
CALC[ has h-routine] USING item-name-2, ...
⎩ DUPLICATES ARE[ NOT] ALLOWED ⎭
item-name-1
must designate a database key item.
If you specify LOCATION MODE IS DIRECT, you must define item-name-1 as a
DATABASE-KEY item.
If you specify LOCATION MODE IS DIRECT-LONG, you must define
item-name-1
If you specify LOCATION MODE IS DIRECT, you must define item-name-1 as a
DATABASE-KEY item.
If you specify LOCATION MODE IS DIRECT-LONG, you must define
item-name-1
as a DATABASE-KEY-LONG item.
item-name-2
must specify an item of fixed length belonging to the record type.
You use LOCATION MODE IS DIRECT/DIRECT-LONG to enable you to assign the
database key of a record which is to be saved and to specify the sequence for sequential
processing.
database key of a record which is to be saved and to specify the sequence for sequential
processing.
You use LOCATION MODE IS CALC to specify a primary key to permit direct access to a
particular record or to a set of records with the same key values.
particular record or to a set of records with the same key values.
i