Data Definition Language (DDL) Reference Manual

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual529431-004
D-34
DICTOBL (Object Build List)
14 Numeric string leading embedded sign
15 Numeric string leading separate sign
17 Logical*1
19 Logical*2
21 Logical*4
22 Binary 8 signed
23 Binary 8 unsigned
24 SQL VARCHAR
25 Enumeration
26 Bit signed
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
Table D-11. STRUCTURE Codes (page 2 of 3)
Code Meaning