|
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 |
|
|
|
|
|
|
|
|
|