Import Code |
CONNX Data Type |
SQL Data Type |
SQL Length |
VMS Equivalent Data Types |
Description |
119 |
ADL Math |
DOUBLE |
8 |
|
Site-specific. |
120 |
ADL MMIS Number |
CHAR |
23 |
|
Site-specific. |
121 |
ADL Date |
DATE |
6 |
|
Site-specific. |
122 |
ADL GL Number |
DOUBLE |
8 |
|
Site-specific. |
123 |
ADL Type Code |
VARCHAR |
5 |
|
Site-specific. |
124 |
ADL Zip Code |
LONG |
4 |
|
Site-specific. |
125 |
ADL Old Math |
VARCHAR |
16 |
|
Site-specific. |
126 |
Flex Text |
CHAR |
-1 |
|
|
127 |
Flex Double |
DOUBLE |
8 |
|
|
128 |
Flex Longword |
INTEGER |
4 |
|
|
129 |
Flex Date |
DATE |
6 |
|
|
130 |
Flex Binary |
BINARY |
-1 |
|
|
131 |
String Tinyint |
TINYINT |
1 |
|
|
132 |
String Smallint |
SMALLINT |
2 |
|
|
133 |
String Integer |
INTEGER |
4 |
|
|
134 |
String Quadword |
VARCHAR |
20 |
|
|
135 |
String Single |
REAL |
4 |
|
|
136 |
String Double |
DOUBLE |
8 |
|
|
137 |
RDB Date VMS |
TIMESTAMP |
16 |
|
|
138 |
RDB Date ANSI |
DATE |
6 |
|
|
139 |
RDB Time |
TIME |
6 |
|
|
140 |
RDB Timestamp |
TIMESTAMP |
16 |
|
|
141 |
Interval Day |
DOUBLE |
8 |
|
|
142 |
Interval Hour |
DOUBLE |
8 |
|
|
143 |
Interval Minute |
DOUBLE |
8 |
|
|
144 |
Interval Date Day/Second |
DOUBLE |
8 |
|
|
145 |
Interval Date Hour |
DOUBLE |
8 |
|
|
146 |
Interval Date Hour/Minute |
DOUBLE |
8 |
|
|
147 |
Interval Date Hour/Second |
DOUBLE |
8 |
|
|
148 |
Interval Date Minute |
DOUBLE |
8 |
|
|
149 |
Interval Date Minute/Second |
DOUBLE |
8 |
|
|
150 |
Interval Date Month |
DOUBLE |
8 |
|
|
151 |
Interval Date Second |
DOUBLE |
8 |
|
|
152 |
Interval Date Year |
DOUBLE |
8 |
|
|
153 |
Interval Date Year/Month |
DOUBLE |
8 |
|
|
154 |
Morse Date |
DATE |
6 |
|
Site-specific. |
155 |
Allport Julian Date (2 byte) |
DATE |
6 |
|
Site-specific. |
156 |
VMS X Float |
DOUBLE |
8 |
|
X Float VMS IEEE X Float |
157 |
Reverse VMS Date (6 byte) |
DATE |
6 |
|
Reversed VMS Date stored in 6 bytes (fractional second precision is truncated). |
158 |
VMS Date (6 byte) |
DATE |
6 |
|
VMS Date stored in 6 bytes (fractional second precision is truncated). |
159 |
VMS S Float |
REAL |
4 |
S Float |
VMS IEEE single-precision floating point. |
160 |
VMS T Float |
DOUBLE |
8 |
T Float |
VMS IEEE double-precision floating point. |
161 |
KCS Compressed Integer |
INTEGER |
4 |
|
Site-specific. |
162 |
KCS Phone |
CHAR |
10 |
|
Site-specific. |
163 |
KCS Zip Code |
CHAR |
9 |
|
Site-specific. |
164 |
KCS Time (2 byte) |
TIME |
6 |
|
Site-specific. |
165 |
KCS Time (3 bytes) |
TIME |
6 |
|
Site-specific. |
166 |
Unsigned Word |
INTEGER |
4 |
|
Unsigned Word |
167 |
KCS Date (3 bytes) |
DATE |
6 |
|
Site-specific. |
168 |
Variable Length Int -> intr |
CHAR |
20 |
|
Integer data type. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc.) |
169 |
Variable Length Int -> Dbl Decimal |
CHAR |
20 |
|
Integer date type with implied decimal precision. This type is designed to handle irregular integer sizes (3 bytes, 6 bytes, etc.) |
170 |
DIBOL Date (5 bytes) |
DATE |
6 |
|
|
171 |
Quadword -> Double |
DOUBLE |
8 |
|
|
172 |
ZZ(deprecated) DB2 Binary |
BINARY |
-1 |
|
|
173 |
ZZ(deprecated DB2 Variable |
VARBINARY |
-1 |
|
|
174 |
ZZ(deprecated) DB2 Long |
LONG VARBINARY |
-1 |
|
|
175 |
ZZ*deprecated) DB2 CHAR |
CHAR |
-1 |
|
|
176 |
ZZ(deprecated) DB2 VARCHAR |
VARCHAR |
-1 |
|
|
177 |
ZZ(deprecated) DB2 LONGVARCHAR |
LONGVARCHAR |
-1 |
|
|
178 |
Word 2 Bytes |
SMALLINT |
2 |
|
|
179 |
DB2 Word Big Endian |
SMALLINT |
2 |
|
|
180 |
Longword 4 bytes |
INTEGER |
4 |
|
|
181 |
DB2 Longword Big Endian |
INTEGER |
4 |
|
|
182 |
DB2 Numeric |
NUMERIC |
-6 |
|
|
183 |
DB2 Numeric -> Integer |
LONG |
4 |
|
|
184 |
DB2 Packed Decimal |
DECIMAL |
-7 |
|
|
185 |
DB2 Packed Decimal -> Integer |
INTEGER |
4 |
|
|
186 |
DB2 ISO Date (YYYY-MM-DD) |
DATE |
6 |
|
|
187 |
DB2 USA Date (mm/dd/yyyy) |
DATE |
6 |
|
|
188 |
DB2 Eur Date (dd.mm.yyyy) |
DATE |
6 |
|
|
189 |
DB2 JIS Date (YYYY-MM-DD) |
DATE |
6 |
|
|
190 |
DB2 ISO Time (hh.mm.ss) |
TIME |
6 |
|
|
191 |
DB2 USA Time (hh:mm xM) |
TIME |
6 |
|
|
192 |
DB2 Eur Time (hh.mm.ss) |
TIME |
6 |
|
|
193 |
DB2 JIS Time (hh:mm:ss) |
TIME |
6 |
|
|
194 |
DB2 Timestamp |
TIMESTAMP |
16 |
|
|
195 |
DB2 IEEE 4-byte float |
REAL |
4 |
|
|
196 |
DB2 IEEE Big E 4-byte float |
REAL |
4 |
|
|
197 |
DB2 IEEE 8-byte float |
DOUBLE |
8 |
|
|
198 |
DB2 IEEE Big E 8-byte float |
DOUBLE |
8 |
|
|
199 |
DB2 Mainframe 4-byte float |
REAL |
4 |
|
|
200 |
DB2 Mainframe 8-byte float |
DOUBLE |
8 |
|
|
201 |
Decimal |
DECIMAL |
-6 |
|
|
202 |
CLOB |
LONG VARCHAR |
-1 |
|
|
203 |
BLOG |
LONG VARBINARY |
-1 |
|
|
204 |
Oracle Date |
TIMESTAMP |
16 |
|
|
205 |
Oracle Rowid |
BINARY |
-1 |
|
|
206 |
Oracle MLSLabel |
BINARY |
-1 |
|
|
207 |
Varbinary |
VARBINARY |
-1 |
|
|
208 |
OLE DB Date |
DATE |
6 |
|
|
209 |
OLE DB Time |
TIME |
6 |
|
|
210 |
OLE DB Timestamp |
TIMESTAMP |
16 |
|
|
211 |
OLE DB Number |
NUMERIC |
-6 |
|
|
212 |
OLE DB WSTR |
UNICODE |
-1 |
|
|
213 |
OLE DB Decimal |
DECIMAL |
-6 |
|
|
214 |
Unsigned Long |
INTEGER |
4 |
|
|
215 |
Unsigned Byte |
TINYINT |
1 |
|
|
216 |
OLE DB real |
REAL |
4 |
|
|
217 |
OLE DB double |
DOUBLE |
8 |
|
|
218 |
Text (Space Padded) No Nulls |
CHAR |
-1 |
|
|
219 |
Big Double |
DOUBLE |
8 |
|
|
220 |
Big Double Text |
CHAR |
48 |
|
|
221 |
BOSS Date CCYY |
DATE |
6 |
|
Site-specific, 6-byte, Y2K-compliant date. |
222 |
BOSS Year CCYY |
SMALLINT |
2 |
|
Site-specific, 4-byte, Y2K-compliant year. |
223 |
BOSS Julian CCYY |
DATE |
6 |
|
Site-specific, 5-byte, Y2K-compliant year. |
224 |
Packed Decimal COMP6 -> Double |
DOUBLE |
8 |
VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 |
Packed Decimal (1-255 bytes) converts to a double precision floating point; same as Packed Decimal (Double) but unsigned. |
225 |
Packed Decimal COMP6 -> Integer |
LONG |
4 |
VMS Packed Decimal PIC S9(X1)V9(X2) COMP-3 |
Packed Decimal (1-255 bytes) converts to a Long; same as Packed Decimal (Integer) but unsigned. |