Data Definition Language (DDL) Reference Manual

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual—529431-004
D-35
DICTOBL (Object Build List)
54 SQL DATETIME SECOND TO FRACTION
55 SQL DATETIME MINUTE TO FRACTION
56 SQL DATETIME HOUR TO FRACTION
57 SQL DATETIME DAY TO FRACTION
58 SQL DATETIME MONTH TO FRACTION
59 SQL DATETIME YEAR TO FRACTION
60 SQL INTERVAL YEAR
61 SQL INTERVAL MONTH
62 SQL INTERVAL YEAR TO MONTH
63 SQL INTERVAL DAY
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-12. 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
Table D-11. STRUCTURE Codes (page 3 of 3)
Code Meaning