|
CONNX Data Type |
SQL Data Type |
Length |
Description |
|
Double Prec float (Mainframe) |
DOUBLE |
8 |
8-byte big-endian mainframe double precision: USAGE COMP-2. |
|
Longword (BE) |
INTEGER |
4 |
Signed big-endian 4-byte INTEGER PIC S9(n) COMP, where 5 <= n <= 9. |
|
PACKED (F) Decimal -> Double |
DOUBLE |
1-10
|
Unsigned Packed Decimal PIC 9(precision,scale) USAGE COMP-3, where scale > 0 or 10 <= precision <= 18, or both. |
|
PACKED (F) Decimal -> Integer |
LONG |
1-5
|
Unsigned Packed Decimal PIC 9(n) USAGE COMP-3, where 1 <= n <= 9. |
|
PACKED Decimal -> Decimal |
DECIMAL |
1-10 |
Signed Packed Decimal PIC S9(precision,scale) USAGE COMP-3, where scale > 0 or 10 <= precision <= 18, or both. |
|
PACKED Decimal |
LONG |
1-5 |
Signed Packed Decimal PIC S9(n) USAGE COMP-3, where 1 <= n <= 9. |
|
Signed Overpunch |
DECIMAL |
1-18 |
Signed Numeric Display PIC S9(precision,scale), where scale > 0 or 10 <= precision <= 18, or both. |
|
Signed Overpunch |
LONG |
1-9 |
Signed Numeric Display PIC S9(n), where 1 <= n <= 9. |
|
Single Prec float (Mainframe) |
REAL |
4 |
4-byte big-endian mainframe float: USAGE COMP-1. |
|
Text -> Decimal |
DECIMAL |
1-18 |
Unsigned Numeric Display PIC 9(precision,scale), where scale > 0 or 10 <= precision <= 18, or both. |
|
Text -> Integer |
INTEGER |
1-9 |
Unsigned Numeric Display PIC 9(n), where 1 <= n <= 9 |
|
Text (Right Space Padded) |
CHAR |
1-32767 |
Character display PIC X(nnnnn), where 1 <= n <= 32767 |
|
Unsigned Long 4 bytes (BE) |
INTEGER |
4 |
Unsigned big-endian 4-byte INTEGER PIC S9(n) COMP, where 5 <= n <= 9. |
|
Unsigned Word 2 Bytes (BE) |
SMALLINT |
2 |
Unsigned big-endian 2-byte INTEGER PIC 9(n) COMP, where 1 <= n <= 4. |
|
Word (BE) |
SMALLINT |
2 |
Signed big-endian 2-byte INTEGER PIC S9(n) COMP, where 1 <= n <= 4. |