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
|
|
All of the CONNX data types have been provided in the tables in the next several topics under CONNX Data Types, although only the text-based CONNX data types can be used with Adabas.