Filter
Top Products
Defining an item Schema DDL
62 U929-J-Z125-9-76
Since the record must also contain at least the record length item item-name-2 in addition to
the variable item, the maximum length of the variable item is equal to:
– 2010 bytes for a 2048-byte page length
– 3958 bytes for a 4000-byte page length
– 8054 bytes for a 8096-byte page length
If the record includes other items besides the variable item and the record length item, the
maximum length of the variable item decreases accordingly.
Furthermore, the following restrictions apply for variable items:
– There may be only one variable item for each record type; it must also be the last item.
– A variable-length item may not be defined as a key item, nor used for direct access to
records.
– A record type containing a variable item may not be restructured by means of
subschema DDL. It must be taken over into the subschema as defined by the schema
DDL.
– A record type containing an item of variable length cannot be addressed with SQL.
Example
RECORD NAME IS ARTICLE MASTER
DATA-ITEM-1 TYPE IS
. .
. .
. .
LENGTH-ITEM TYPE IS BINARY 15.
ARTICLE-INFO PICTURE IS LX(500) DEPENDING ON LENGTH ITEM.