Given the following scenario:
Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once
TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1.
Which of the following would be the most appropriate DB2 data type to use for column COL1?
A.
INTEGER
B.
REAL
C.
NUMERIC(7, 3)
D.
DECIMAL(10, 3)
DECIMAL(p,s)
Exact numerical, precision p, scale s. Example: decimal(5,2) is a number that has 3 digits before the decimal and 2 digits after the decimal
http://www.w3schools.com/sql/sql_datatypes_general.asp
0
0