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

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual—426798-002
D-23
DICTOBL Fields
•
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 Table D-4.
64 SQL INTERVAL HOUR
65 SQL INTERVAL DAY TO HOUR
66 SQL INTERVAL MINUTE
67 SQL INTERVAL HOUR TO MINUTE
68 SQL INTERVAL DAY TO MINUTE
69 SQL INTERVAL SECOND
70 SQL INTERVAL MINUTE TO SECOND
71 SQL INTERVAL HOUR TO SECOND
72 SQL INTERVAL DAY TO SECOND
73 SQL INTERVAL FRACTION
74 SQL INTERVAL SECOND TO FRACTION
75 SQL INTERVAL MINUTE TO FRACTION
76 SQL INTERVAL HOUR TO FRACTION
77 SQL INTERVAL DAY TO FRACTION
Table D-4. SQL DATETIME Element Sizes (page 1 of 2)
Code Meaning Element Size
32 SQL DATETIME YEAR 4
33 SQL DATETIME MONTH 2
34 SQL DATETIME YEAR TO MONTH 7
35 SQL DATETIME DAY 2
36 SQL DATETIME MONTH TO DAY 5
37 SQL DATETIME YEAR TO DAY 10
38 SQL DATETIME HOUR 2
39 SQL DATETIME DAY TO HOUR 5
40 SQL DATETIME MONTH TO HOUR 8
41 SQL DATETIME YEAR TO HOUR 13
Table D-3. STRUCTURE Codes (page 3 of 3)
Code Meaning