Import Codes 266-356

Import Code | CONNX Data Type | SQL Data Type | SQL Length | VMS Equivalent Data Types | Description
266 | Word (BE) -> Double | DOUBLE | 8 |  |
267 | Longword Decimal Big Endian | DOUBLE | 8 |  |
268 | Binary (Text) Reversed | CHAR | -2 |  |
269 | Comment Prefix | VARCHAR | -8 |  |
270 | Float IEEE 4-byte | REAL | 4 |  |
271 | Float IEEE 4-byte (BE) | REAL | 4 |  |
272 | Double IEEE 8-byte | DOUBLE | 8 |  |
273 | Double IEEE 8-byte (BE) | DOUBLE | 8 |  |
274 | CISAM Packed Decimal 1 | DOUBLE | 8 |  |
275 | CISAM Packed Decimal 2 | VARCHAR | 128 |  |
276 | PROIV Date | DATE | 6 |  |
277 | Astrazeneca Interval | VARCHAR | 18 |  |
278 | CISAM Zoned Numeric -> Double | DOUBLE | 8 |  |
279 | CISAM Zoned Numeric -> Integer | LONG | 4 |  |
280 | CISAM DIBOL Date (5 bytes) | DATE | 6 |  |
281 | Time (Text HHMM) | TIME | 6 |  |
282 | Time (Text HHMMSS) | TIME | 6 |  |
283 | Pinnacle Date | DATE | 6 |  |
284 | Quadword (BE) -> Char | VARCHAR | 20 |  |
285 | Quadword (BE) -> Char (DP) | VARCHAR | 20 |  |
286 | VarLen Int (BE) -> Char | CHAR | 20 |  |
287 | VarLen Int (BE) -> Char DP | CHAR | 20 |  |
288 | Quadword (BE) -> Double | DOUBLE | 8 |  |
289 | VarLen Int (BE) -> Double | DOUBLE | 8 |  |
290 | VarLen Int -> Double | DOUBLE | 8 |  |
291 | Unsigned Word 2 bytes (BE) | SMALLINT | 2 |  |
292 | Unsigned Long 4 bytes (BE) | INTEGER | 4 |  |
293 | Unsigned Word Decimal (BE) | DOUBLE | 8 |  |
294 | Unsigned Long (BE) -> Double | DOUBLE | 8 |  |
295 | Unsigned Quad (BE) -> Char | VARCHAR | 20 |  |
296 | Unsigned Quad (BE) -> Char(DP) | VARCHAR | 20 |  |
297 | Unsigned VarLen Int(BE)->Char | CHAR | 20 |  |
298 | Unsigned VarLen Int(BE)->Char(DP) | CHAR | 20 |  |
299 | Unsigned Quadword Double (BE) | DOUBLE | 8 |  |
300 | Unsigned VarLen Int (BE) -> Dbl | DOUBLE | 8 |  |
301 | Unsigned Byte Double | DOUBLE | 8 |  | Single unsigned byte value converts to a SQL Double
302 | PostgreSQL Timestamp | TIMESTAMP | 16 |  |
303 | PostgreSQL Date | DATE | 6 |  |
304 | PostgreSQL Time | TIME | 8 |  |
305 | CA Window | VARCHAR | 155 |  |
306 | CA Bit Flag | INTEGER | 4 |  | Customer-specific (1 byte of individual bit flags)
307 | 4C Date | DATE | 6 |  | Date in the form of days since 12/31/1799 converts to SQL Date
308 | Gestepargne Date | DATE | 6 |  |
309 | Byte Numeric -> Decimal | DECIMAL | 5 |  | Single signed byte value converts to a SQL Decimal
310 | Word Numeric -> Decimal | DECIMAL | 7 |  | Two-byte signed value converts to a SQL Decimal
311 | Longword -> Decimal | DECIMAL | 12 |  | Three-byte signed value converts to a SQL Decimal
312 | Quadword -> Decimal | DECIMAL | 21 |  | Four-byte signed value converts to a SQL Decimal
313 | Zoned Numeric-> Decimal | DECIMAL | -6 |  | String of digits with sign overpunched in lowest (right) digit converts to SQL Decimal
314 | Packed Decimal -> Decimal | DECIMAL | -7 |  | Packed decimal converts to SQL Decimal
315 | Signed Overpunch -> Decimal | DECIMAL | -6 |  | Overpunched decimal converts to SQL Decimal
316 | PACKED (A) Decimal -> Decimal | DECIMAL | -7 |  | Packed decimal to SQL Decimal, value of 'A' denotes negative
317 | PACKED (E) Decimal -> Decimal | DECIMAL | -7 |  | Packed decimal to SQL Decimal, value of 'E' denotes negative
318 | PACKED (F) Decimal -> Decimal | DECIMAL | -7 |  | Packed decimal to SQL Decimal, value of 'F' denotes negative
319 | Left Separate -> Decimal | DECIMAL | -10 |  | Character to SQL Decimal with leading sign
320 | Right Separate -> Decimal | DECIMAL | -10 |  | Character to SQL Decimal with trailing sign
321 | National Compressed -> Decimal | DECIMAL | -11 |  | Customer-specific numeric to SQL Decimal
322 | Flex Numeric | DECIMAL | -1 |  |
323 | VarLen Integer -> Decimal | DECIMAL | -11 |  | Binary variable length integer to SQL Decimal
324 | POISE Txt (Right Pad) -> Decimal | DECIMAL | -1 |  | Customer-specific character to SQL Decimal
325 | PACKED Decimal COMP6 -> Decimal | DECIMAL | -13 |  | Unsigned packed decimal to SQL Decimal
326 | CISAM Zoned Numeric -> Decimal | DECIMAL | -6 |  |
327 | Quadword (BE) -> Decimal | DECIMAL | 21 |  |
328 | VarLen Int -> Decimal | DECIMAL | -11 |  | Integer (2, 4, 8 bytes) to SQL Decimal (string) (DEPRECATED)
329 | Unsigned Quadword(BE) -> Dec | DECIMAL | 21 |  |
330 | VarLen Int (BE) -> Decimal | DECIMAL | -11 |  |
331 | Unsigned VarLen Int(BE)->Dec | DECIMAL | -12 |  |
332 | Text -> Decimal | DECIMAL | -6 |  | Character to SQL Decimal
333 | Unsigned Byte -> Decimal | DECIMAL | 5 |  | Unsigned byte number to SQL Decimal
334 | Unsigned Word (BE) -> Decimal | DECIMAL | 7 |  |
335 | Unsigned Long (BE) -> Decimal | DECIMAL | 12 |  |
336 | Word (BE) -> Decimal | DECIMAL | 7 |  |
337 | Longword (BE) -> Decimal | DECIMAL | 12 |  |
338 | RDB Date VMS (String) | TIMESTAMP | 16 |  |
339 | Mark BIB Number | LONG | 4 |  |
340 | Unsigned PK(F) Dt (DDMMYY) | DATE | 6 |  | Packed date DDMMYY to SQL Date
341 | Unsigned PK(F) Dt (DDMMYYYY) | DATE | 6 |  | Packed date DDMMYY to SQL Date
342 | Unsigned PK(F) Dt (YYMMDD) | DATE | 6 |  | Packed date YYMMDD to SQL Date
343 | Unsigned PK(F) Dt (YYYYMMDD) | DATE | 6 |  | Packed date YYYYMMDD to SQL Date
344 | Unsigned PK(F) Dt (MMDDYY) | DATE | 6 |  | Packed date MMDDYY to SQL Date
345 | Unsigned PK(F) Dt (MMDDYYYY) | DATE | 6 |  | Packed date MMDDYYYY to SQL Date
346 | Unsigned PK(F) Dt 2000(DDMMYY) | DATE | 6 |  | Packed date DDMMYY date window to SQL Date
347 | Unsigned PK(F) Dt 2000(YYMMDD) | DATE | 6 |  | Packed date YYMMDD date window to SQL Date
348 | Unsigned PK(F) Dt 2000(MMDDYY) | DATE | 6 |  | Packed date MMDDYY date window to SQL Date
349 | CISAM Zoned Decimal | DECIMAL | -6 |  |
350 | Word Big Endian Date (2 bytes) | DATE | 6 |  |
351 | Word Big Endian Time (4 bytes) | TIME | 6 |  |
352 | Word Big Endian Timestamp | TIMESTAMP | 16 |  |
353 | Timestamp12 (YYYYMMDDHHMM) | TIMESTAMP | 16 |  | Character Timestamp with year, month, day, hour, and minute
354 | Timestamp14 (YYYYMMDDHHMMSS) | TIMESTAMP | 16 |  | Character Timestamp with year, month, day, hour, minutes, and second
355 | Vector Timestamp | TIMESTAMP | 16 |  | Unsigned short of year, month, day, hour, minute, second, and 1000ths of a second
356 | Allport Julian Date String | DATE | 6 |  | Character string Julian (jumeric) date offset from 1/1/1970