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

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual—426798-002
D-22
DICTOBL Fields
27 Bit unsigned
28 National string
32 SQL DATETIME YEAR
33 SQL DATETIME MONTH
34 SQL DATETIME YEAR TO MONTH
35 SQL DATETIME DAY
36 SQL DATETIME MONTH TO DAY
37 SQL DATETIME YEAR TO DAY
38 SQL DATETIME HOUR
39 SQL DATETIME DAY TO HOUR
40 SQL DATETIME MONTH TO HOUR
41 SQL DATETIME YEAR TO HOUR
42 SQL DATETIME MINUTE
43 SQL DATETIME HOUR TO MINUTE
44 SQL DATETIME DAY TO MINUTE
45 SQL DATETIME MONTH TO MINUTE
46 SQL DATETIME YEAR TO MINUTE
47 SQL DATETIME SECOND
48 SQL DATETIME MINUTE TO SECOND
49 SQL DATETIME HOUR TO SECOND
50 SQL DATETIME DAY TO SECOND
51 SQL DATETIME MONTH TO SECOND
52 SQL DATETIME YEAR TO SECOND
53 SQL DATETIME FRACTION
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
Table D-3. STRUCTURE Codes (page 2 of 3)
Code Meaning