Data Definition Language (DDL) Reference Manual (G06.24+)

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual—426798-002
D-25
DICTOBL Fields
•
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.
•
ENDING−the last element of the set of elements renamed by a level 66 RENAMES
clause, where this ending element ends at the same position as the renaming
element.
•
TALBOUND−contains a binary value that specifies the lower limit of pTAL or TAL
arrays. Valid values are 0 and 1. The default value for this field is 1.
70 SQL INTERVAL MINUTE TO SECOND 6
71 SQL INTERVAL HOUR TO SECOND 9
72 SQL INTERVAL DAY TO SECOND 12
73 SQL INTERVAL FRACTION 7
74 SQL INTERVAL SECOND TO FRACTION 10
75 SQL INTERVAL MINUTE TO FRACTION 13
76 SQL INTERVAL HOUR TO FRACTION 16
77 SQL INTERVAL DAY TO FRACTION 19
Table D-5. SQL INTERVAL Element Sizes (page 2 of 2)
Code Meaning Element