DB2 data types range and precision

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

Copyright IBM Corporation 2005. All Rights Reserved.