A list of the DB2® data types, their range and precession.
Data type | Range | Precision |
---|---|---|
SMALLINT | -32 768 to 32 767 | 5 digits |
BIGINT | -9 223 372 036 854 775 808 to +9 223 372 036 854 775 807 | 19 digits |
INTEGER | -2 147 483 648 to +2 147 483 647 | 10 digits |
DOUBLE | From 1.79769E+308 to -2.225E-307 Or From 2.225E-307 to 1.79769E+308 |
15 digits after the decimal point |
REAL | From -3.402E+38 to -1.175E-37 Or From 1.175E-37 to 3.402E+38 |
7 digits after the decimal point |
DECIMAL | -10**31+1 to 10**31-1 | The defined maximum number of digits. For example, the precision of a column defined as NUMERIC(10,3) is 10 |