Fujitsu UDS/SQL V2.5 사용자 설명서
Schema DDL
Defining an item
U929-J-Z125-9-76
61
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
integer
specifies the number of storage locations the item contains, each storage location
being able to contain one character of the character set.
4.2.5
Defining an alphanumeric item of variable length
⎧PICTURE IS LX(integer) ⎫
[level-number ]item-name-1
⎨ ⎬
⎩TYPE IS CHARACTER integer⎭
DEPENDING ON item-name-2.
Alphanumeric items of variable length can contain any type of character.
level-number
denotes whether the item is part of a repeating group. As items of variable
length may not be part of a repeating group, the specified level number must be the smallest
level number in the whole record type.
level number in the whole record type.
item-name-1
specifies the name assigned by the user.
integer
specifies the maximum length of the variable-length item, i.e. it denotes the
maximum number of storage locations, where each storage location can contain any
character of the character set. The value specified for integer must be > 0.
character of the character set. The value specified for integer must be > 0.
item-name-2
specifies the name of an item that must have been defined immediately before
the variable item as a binary item with a value range of 0 through 2
15
-1. Before storing or
updating a record containing a variable item, the database programmer must specify the
current length of the variable item in the item-name-2 item. This (current) length may also be
0, in which case, neither the variable item nor the record length item are stored in the
database.
current length of the variable item in the item-name-2 item. This (current) length may also be
0, in which case, neither the variable item nor the record length item are stored in the
database.
Depending on which page length has been defined for the database, the maximum length
of a record with a variable item must not exceed the following values:
of a record with a variable item must not exceed the following values:
–
2012 bytes for a 2048-byte page length (2-Kbyte page format)
–
3960 bytes for a 4000-byte page length (4-Kbyte page format)
–
8056 bytes for a 8096-byte page length (8-Kbyte page format)
The maximum length of a record containing a variable item could, however, also be
somewhat lower, depending on the connection data for the record (see “SCD” on
somewhat lower, depending on the connection data for the record (see “SCD” on
).