Import Codes 407-443

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