Feeds:
Posts
Comments

Archive for the ‘Mainframe Datatypes’ Category

Mainframe data type mapping with Db2 & java

Posted in Mainframe Datatypes, tagged , , on March 27, 2008 | Leave a Comment »

DB2:   SMALLINT
Cobol: PIC S9(5) COMP-3.
Java:  smallDB2:   INTEGER
Cobol: PIC S9(10) COMP-3.
Java:  int
DB2:   DECIMAL(x) (x <= 4)
Cobol: PIC S9(x) COMP-3.
Java:  small
DB2:   DECIMAL(x) (4 < x <=
Cobol: PIC S9(x) COMP-3.
Java:  int
DB2:   DECIMAL(x) (8 < x <= 18)
Cobol: PIC S9(x) COMP-3.
Java:  long
DB2:   DECIMAL(x,y) (x <= 18)
Cobol: PIC S9(x-y)V9(y) COMP-3
Java:  BigDecimal
DB2:   BIGINT [...]

Read Full Post »