Import Codes 119-225

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.