Fujitsu UDS/SQL V2.5 사용자 설명서
Schema DDL
Defining an item
U929-J-Z125-9-76
59
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.2.3
Defining a binary item
⎧15⎫
[level-number ]item-name TYPE IS FIXED REAL BINARY[
⎨ ⎬].
⎩31⎭
Binary items can contain integers only. They are used exclusively as computational items
by the database programmer and cannot be printed without prior editing by a DML program.
Binary items require less storage space and can be processed faster than packed or
unpacked items.
by the database programmer and cannot be printed without prior editing by a DML program.
Binary items require less storage space and can be processed faster than packed or
unpacked items.
If BINARY 15 items are not aligned to halfwords and BINARY 31 items are not aligned to
words by the user, UDS/SQL aligns them automatically.
words by the user, UDS/SQL aligns them automatically.
level-number
denotes whether the item is part of a repeating group:
If the item is not to be part of a repeating group, the specified level number should be the
smallest level number in the whole record type.
This is especially important if the item is to be used as a key item.
smallest level number in the whole record type.
This is especially important if the item is to be used as a key item.
If the item is to be part of a repeating group, proceed as described on
item-name
specifies the name assigned by the user.
BINARY 15 is used to define a binary item with a value range of -2
15
through 2
15
-1.
BINARY 31 is used to define a binary item with a value range of -2
31
through 2
31
-1.
If you do not specify a number, the default value BINARY 15 is assumed.