Filter
Top Products
Schema DDL Defining an item
U929-J-Z125-9-76 61
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k04
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.
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.
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.
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:
– 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
page 219).