Adabas Data Type | CONNX Data Type | SQL Data Type | Length | Description |
Adabas Text (LA VarChar) | VarChar | -1 | ||
Adabas Text (L4 VarChar) | VarChar | -1 | ||
ADABASPACKED | Adabas PACKED Decimal -> Integer | LONG | -1 | |
ADABASPACKED_NUMERIC | Adabas PACKED Decimal -> Decimal | DECIMAL | -1 | |
NATURALTIMESTAMP_DATE | Adabas Natural Timestamp -> Date | DATE | 7 | |
Alphanumeric | Char (Right Space Padded) | CHAR | 253 | Adabas Alphanumeric |
Binary | Binary (Text) | BINARY | 1-126 | Adabas Binary |
Double IEEE 8-byte (BE) | Double IEEE 8-byte (BE) | DOUBLE | 8 | |
Double IEEE 8-byte | Double IEEE 8-byte | DOUBLE | 8 | |
Fixed Point <= 2 digits | Word (BE) - mainframe Word - Non-mainframe | SMALLINT | 1-2 | Adabas Fixed Point with Lengths <= 2 |
Fixed Point > 2 digits | Longword (BE) - mainframe Longword - Non-mainframe | INTEGER | >2 | Adabas Fixed Point with Lengths > 2 |
Float Point (4 bytes) | Single Prec float (mainframe) - mainframe Float IEEE 4-byte - Non-mainframe | REAL | 4 | Adabas Floating Point for Lengths <= 4 |
Float Point (8 bytes) | Double Prec float (mainframe) - mainframe Double IEEE 8-byte - Non-mainframe | DOUBLE | 8 | Adabas Floating Point for Lengths > 4 |
Longword 4 bytes | Longword | INTEGER | 4 | |
Longword (BE) | Longword (BE) | INTEGER | 4 | |
Longword (BE) -> Decimal | Longword (BE) -> Decimal | DECIMAL | 4 | |
Longword (BE) -> Double | Longword (BE) -> Double | DOUBLE | 4 | |
Natural Date | Adabas Natural Date | DATE | 6 | This type refers to the Natural Data data type. |
Natural Time | Adabas Natural Time | TIME | 6 | This type refers to the Natural Time data type. |
Natural Timestamp | Adabas Natural Timestamp | TIMESTAMP | 12 | This type refers to the Natural Timestamp data type. |
Packed Decimal (Length <= 5) | PACKED Decimal -> Integer | INTEGER | <= 5 | Adabas Packed Decimal with Lengths <= 5 |
Packed Decimal | PACKED Decimal -> Decimal | DECIMAL | > 0 | |
Quadword (BE) -> Char (DP) | Quadword (BE) -> Char (DP) | VARCHAR | 8 | |
Quadword (BE) -> Char | Quadword (BE) -> Char | VARCHAR | 8 | |
Quadword (BE) -> Decimal | Quadword (BE) -> Decimal | DECIMAL | 8 | |
Quadword (BE) -> Double | Quadword (BE) -> Double | DOUBLE | 8 | |
Unicode Char (UTF-8) | Unicode | -1 | ||
Unicode L4 VarChar (UTF-8) | Unicode | -1 | ||
Unicode LA VarChar (UTF-8) | Unicode | -1 | ||
Unicode VarChar (UTF-8) | Unicode | -1 | ||
Unpacked Decimal (Length < 10) | Adabas Unpacked EBCDIC (Integer) - mainframe Adabas Unpacked Decimal -> Integer - Non-mainframe | INTEGER | < 10 | Adabas Unpacked Decimal with Lengths < 10 |
Unpacked Decimal | Adabas Unpacked EBCDIC (Numeric) - mainframe Adabas Unpacked -> Decimal- Non-mainframe | NUMERIC | > 0 |