CONNX Data Integration Suite 14.8.0 | Reference Guide | Data Types | Non-Relational Databases | IBM Mainframe Data Types
 
IBM Mainframe Data Types
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
-> Integer
LONG
1-5
Signed Packed Decimal PIC S9(n) USAGE COMP-3, where 1 <= n <= 9.
Signed Overpunch
-> Decimal
DECIMAL
1-18
Signed Numeric Display PIC S9(precision,scale), where scale > 0 or 10 <= precision <= 18, or both.
Signed Overpunch
-> Integer
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.