Defining an item Schema DDL
62 U929-J-Z125-9-76
Since the record must also contain at least the record length item item-na me-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 len gth 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 mean s 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 a ddressed with SQL.
Example
RECORD NAME IS ARTICLE MASTER
DATA-ITEM-1 TYPE IS
. .
. .
. .
LENGTH-ITEM TYPE IS BIN ARY 15.
ARTICLE-INFO PICTURE IS LX(500) DEPENDING ON LENGTH ITEM.