Import Codes 444-500

Import Code | CONNX Data Type | SQL Data Type | SQL Length | VMS Equivalent Data Types | Description
444 | Adabas Text (LA VarChar) | Varchar | -1 |  |
445 | Adabas Text (L4 VarChar) | Varchar | -1 |  |
446 | Unicode Char (UTF-8) | Unicode | -2 |  |
447 | Unicode Char (UTF-8) | VarUnicode | -2 |  |
448 | Unicode LA VarChar (UTF-8) | VarUnicode | -2 |  |
449 | Unicode L4 VarChar (UTF-8) | VarUnicode | -2 |  |
450 | ODBC Bit (not used) | Bit | 1 |  |
451 | ODBC Tiny Integer (not used) | TinyInt | 1 |  |
452 | ODBC Date | Date | 6 |  |
453 | ODBC Time | Time | 6 |  |
454 | ODBC Timestamp | Timestamp | 16 |  |
455 | Maestro Date (DD/MM/YYYY) | Date | 6 |  |
456 | PRO IV Text Integer -> Date | Date | 6 |  |
457 | TextDBMS Variable Text | VarChar | -1 |  |
458 | VMS Time with Precision | VarChar | 18 |  |
459 | OLEDB Variable Length WSTR | VarUnicode | -1 |  |
460 | Unicode CLOB | VarUnicode | -1 |  |
461 | OLEDB WSTR (BE) | Unicode | -1 |  |
462 | OLEDB Variable Length WSTR(BE) | VarUnicode | -1 |  |
463 | Unicode CLOB (BE) | VarUnicode | -1 |  |
464 | ODBC Char | Char | -1 |  |
465 | Adabas Natural Date [Iterative] | Date | 6 |  |
466 | ZZ [deprecated] Adabas Natural Date Unpacked [Iterative] | Date | 6 |  |
467 | ZZ [deprecated] Adabas Natural Timestamp Unpacked [Iterative] | Timestamp | 16 |  |
468 | Adabas Natural Timestamp [Iterative] | Timestamp | 16 |  |
469 | Adabas Natural Timestamp -> Date [Iterative] | Date | 6 |  |
470 | Text seconds since midnight (SSSSS) | Time | 6 |  |
471 | PACKED Decimal 3.5 -> double | Double | 8 |  |
472 | CONNXStore TID | VarChar | 18 |  |
473 | CONNXStore TID (BE) | VarChar | 18 |  |
474 | ODBC Small Integer | SmallInt | 2 |  |
475 | ODBC Unsigned Small Integer | SmallInt | 2 |  |
476 | ODBC Integer | Integer | 4 |  |
477 | ODBC Unsigned Integer | Integer | 4 |  |
478 | ODBC Big Integer | Bigint | 8 |  |
479 | ODBC Unsigned Big Integer | Bigint | 8 |  |
480 | ODBC Real | Double | 8 |  |
481 | ODBC Double | Double | 8 |  |
482 | Quadword (BE) | Bigint | 4 |  |
483 | Quadword (BE) Unsigned | Bigint | 4 |  |
484 | Quadword | Bigint | 4 |  |
485 | FHP Julian Day Integer | Date | 6 |  |
486 | FHP Julian Day String | Date | 6 |  |
487 | APCO Small Date (3 bytes) | Date | 6 |  |
488 | APCO Hex Nybbles | Integer | 4 |  |
489 | APCO Small Date (4 bytes) | Date | 6 |  |
490 | APCO 4C Date | Date | 6 |  |
491 | Word Big Endian Date | Date | 6 |  |
492 | DB2 Bigint | Bigint | 4 |  |
493 | DB2 Bigint Big Endian | Bigint | 4 |  |