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 |