Data Type In DB2 at 19:14

SMALLINT	A small two-byte integer with precision of 5 digits.
INTEGER INT	A large four-byte integer with precision of 10 digits. Has a range from –2 147 483 648 to +2 147 483 647.
BIGINT	A big eight-byte integer with precision up to 19 digits.
FLOAT DOUBLE	A double-precision floating point number. An eight-byte approximation of a real number. Imprecise.
REAL	A single-precision floating point number. A four-byte approximation of a real number. Imprecise.
DECIMAL NUMERIC	Used for decimal numbers. Decimal point is determined by precision and scale.
CHAR	Fixed-length storage for a sequence of characters and numbers. Generally used for smaller character strings where performance is more important than storage.
VARCHAR	Used for variable-length character strings where storage is more important than performance. Generally used for larger character strings that can vary in length. Maximum size depends on table space page size.
BLOB	Binary large object, which is used for binary data. Can be used for pictures or other types of binary files. The performance of BLOBs is not as good as structured data such as characters or integers but is used for storing unstructured data. Tip: You can use VARCHAR FOR BIT DATA for small objects if performance is a major consideration.
CLOB	Character large object. Used to store vary large strings beyond the limits of the VARCHAR data type.
DBCLOB	Double-byte character large object. Like CLOB but used to store very large multi-byte character strings (such as Chinese characters) beyond the limits of VARGRAPHIC.
GRAPHIC	Like a CHAR type, but used to store multibyte character strings (such as Chinese characters).
VARGRAPHIC	Like a VARCHAR type, but used to store multibyte character strings (such as Chinese characters).
DATE	Date data type representing year, month, and day.
TIME	Time data type representing hour, minute, and second of the time of day based on the 24-hour clock.
TIMESTAMP	A value that includes both the time and the date.
DATALINK	Contains a logical reference to a file outside the database.
Distinct type	User-defined type that shares its internal representation with an existing type.
Structured type	User-defined type that has its internal structure defined in the database.