Dictionary Database Structure
Data Definition Language (DDL) Reference Manual — 426798-002
D -24
DICTOBL Fields
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
Table D-5
.
42
SQL DATETIME MINUTE
2
43
SQL DATETIME HOUR TO MINUTE
5
44
SQL DATETIME DAY TO MINUTE
8
45
SQL DATETIME MONTH TO MINUTE
11
46
SQL DATETIME YEAR TO MINUTE
16
47
SQL DATETIME SECOND
2
48
SQL DATETIME MINUTE TO SECOND
5
49
SQL DATETIME HOUR TO SECOND
8
50
SQL DATETIME DAY TO SECOND
11
51
SQL DATETIME MONTH TO SECOND
14
52
SQL DATETIME YEAR TO SECOND
19
53
SQL DATETIME FRACTION
6
54
SQL DATETIME SECOND TO FRACTION
9
55
SQL DATETIME MINUTE TO FRACTION
12
56
SQL DATETIME HOUR TO FRACTION
15
57
SQL DATETIME DAY TO FRACTION
18
58
SQL DATETIME MONTH TO FRACTION
21
59
SQL DATETIME YEAR TO FRACTION
26
Table D-5. SQL INTERVAL Element Sizes (page 1 of 2)
Code Meaning
Element
60
SQL INTERVAL YEAR
3
61
SQL INTERVAL MONTH
3
62
SQL INTERVAL YEAR TO MONTH
6
63 SQL
INTERVAL
DAY
3
64
SQL INTERVAL HOUR
3
65
SQL INTERVAL DAY TO HOUR
6
66
SQL INTERVAL MINUTE
3
67
SQL INTERVAL HOUR TO MINUTE
6
68
SQL INTERVAL DAY TO MINUTE
9
69
SQL INTERVAL SECOND
3
Table D-4. SQL DATETIME Element Sizes (page 2 of 2)
Code
Meaning
Element Size
