Adabas Data Types
The following table contains the available data types for Adabas databases supported by CONNX.

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 |