Import Code |
CONNX Data Type |
SQL Data Type |
SQL Length |
VMS Equivalent Data Types |
Description |
---|---|---|---|---|---|
407 |
OLEDB VAR-WSTR |
CHAR |
-1 |
|
|
408 |
MG Word Date |
DATE |
6 |
|
|
409 |
ZZ[deprecated] Adabas Natural Date Unpacked |
DATE |
6 |
|
|
410 |
ZZ[deprecated] Adabas Natural Time Unpacked |
TIME |
6 |
|
|
411 |
Adabas Unpacked Decima->Integer |
LONG |
4 |
|
|
412 |
Adabas Unpacked->Decimal |
DECIMAL |
-6 |
|
|
413 |
Adabas Unpacked EBCDIC(Integer) |
LONG |
4 |
|
|
414 |
Adabas Unpacked EBCDIC(Numeric) |
DECIMAL |
-6 |
|
|
415 |
Cognos PHDate (BE) |
DATE |
6 |
|
|
416 |
Cognos PHDate 2000 (BE) |
DATE |
6 |
|
|
417 |
Adabas Text (VarChar) |
VARCHAR |
-1 |
|
|
418 |
PROMIS Timestamp |
Timestamp |
16 |
|
|
419 |
ZZ[deprecated] Adabas Natural Timestamp |
TIMESTAMP |
16 |
|
|
420 |
Adabas Natural Timestamp |
TIMESTAMP |
16 |
|
|
421 |
Adabas PACKED Decimal -> Integer |
Long |
4 |
|
|
422 |
Adabas PACKED Decimal -> Decimal |
Decimal |
-7 |
|
|
423 |
Adabas Natural Timestamp -> Date |
Date |
6 |
|
|
424 |
Opus Date |
Date |
6 |
|
|
425 |
Opus Date Packed |
Date |
6 |
|
|
426 |
PostgreSQL Timestamp |
Timestamp |
16 |
|
|
427 |
PostgreSQL Date |
Date |
6 |
|
|
428 |
PostgreSQL Time |
Time |
6 |
|
|
429 |
PostgreSQL Numeric (BE) -> Decimal |
Decimal |
-15 |
|
|
430 |
PostgreSQL Numeric (7.4+) -> Decimal |
Decimal |
-15 |
|
|
431 |
PostgreSQL Numeric (7.4+ BE) -> Decimal |
Decimal |
-15 |
|
|
432 |
OPUS Unsigned PACKED -> Decimal |
Decimal |
21 |
|
|
433 |
HCHD Serial Date |
Date |
6 |
|
|
434 |
ANSI/ISO Timestamp |
Timestamp |
16 |
|
|
435 |
Compufast Text Date (YYYYMMDD) |
Date |
6 |
|
|
436 |
Globally Unique ID (GUID) |
Char |
38 |
|
Meant for SQL Server databases, but can be used with any database that supports GUID types. |
437 |
Longword JDate (BE) |
Date |
6 |
|
|
438 |
VIXEN Date |
Date |
6 |
|
The VIXEN Date is in the format DDMMYY. The year value is stored in such a way that if the first digit is 0-9, the decade is in 1900. If the first "digit" is from A-Z, then the decade is offset from 2000, i.e., 99 would be 1999, A9 would be 2009, and B9 would be 2019, etc. |
439 |
Naftha Text |
Char |
-1 |
|
The Naftha Text is a custom datatype that does some character conversions for Arabic data (customer -specific). |
440 |
CS Comment |
Varchar |
-1 |
|
Designed specifically for the Comment fields in Caldwell Spartan software. |
441 |
Julian Timestamp (BE |
TIMESTAMP |
16 |
|
|
442 |
PioTech Numeric |
BIGINT |
8 |
|
|
443 |
PioTech Date |
DATE |
6 |
|
|