Data Definition Language (DDL) Reference Manual

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual—529431-004
D-28
DICTOBL (Object Build List)
ELEMENT-SIZE The number of bytes per occurrence of this element.
The total size of the element is equal to ELEMENT-
SIZE times OCCURS-MAX.
For an SQL VARCHAR element, this field contains
the actual length of the element.
For SQL DATETIME elements, this field contains the
byte length needed for the longest possible ANSI
DATETIME string with a specific SQL DATETIME
qualifier, as listed in Tabl e D-12
on page D-35.
For SQL INTERVAL elements, this field contains the
value of the byte length required for the longest
possible interval string with a specific interval
qualifier, as listed in Tabl e D-13
on page D-36.
SCALE The scale factor in a numeric field; the scale is equal
to the number of positions to the right of the implied
decimal point.
OFFSET The number of bytes from the first byte of the object
to the first byte of this element; byte numbering
begins with 0.
OCCURS-MIN The minimum number of times LOCAL-NAME
occurs; the default value is 1.
If the element is described by an OCCURS min TO
max TIMES DEPENDING ON clause, this field
contains the value of min.
OCCURS-MAX The number of times LOCAL-NAME occurs; the
default value is 1.
If the element is described by an OCCURS max
TIMES clause, this field contains the value max.
OCCURS-MIN-OBJECT If min is defined as a constant, contains the object
number of the constant; otherwise, it is 0.
OCCURS-MAX-OBJECT If max is defined by a constant, contains the object
number of the constant; otherwise, it is 0.
OCCURS-ELEMENT The element number of the field in an OCCURS
DEPENDING ON field-name clause. This element
must be defined as an integer. If there is no
DEPENDING ON clause, the field is set to 0.
STARTING The first element of the set of elements renamed by
a level 66 RENAMES clause, where this starting
element has the same offset as renaming element.
Table D-7. DICTOBL (Object Build List) Fields (page 4 of 8)
Field Description