Db2 Warehouse on Cloud Connector

Back Next

Db2 Warehouse on Cloud and Transformation Data Types

The following table lists the Db2 Warehouse on Cloud data types that

Data Integration

supports and the corresponding transformation data types:

Db2 Warehouse on Cloud Data Type	Transformation Data Type	Description
Smallint	integer	Precision 10; scale 0
Integer	integer	Precision 10; scale 0
Bigint	biginteger	Precision 19; scale 0
Decimal	decimal	Precision 1 to 28; scale 0 to 28
Numeric	decimal	Precision 1 to 28; scale 0 to 28
Real	double	Precision 15; scale 0
Double	double	Precision 15; scale 0
Decfloat	decimal	Precision 1 to 28; scale 0 to 28
Char	string	Precision 254
Varchar	string	Precision 32672
Clob	text	Precision 104857600
Graphic	string	Precision 127
Vargraphic	string	Precision 16336
Binary	binary	Precision 255
Varbinary	binary	Precision 32672
DBclob	text	Precision 104857600
Blob	binary	Precision 104857600
Date	date	Precision 10; Month: 1 Day: 1 Year: 0001 Month: 12 Day: x, where x is 28, 29, 30, or 31, and depends on the month. Year: 9999
Time	date	Precision 8; Hour : 0 Minute : 0 Second : 0 Hour : 24 Minute : 59 Second : 59
Timestamp	date	Precision 26; Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Boolean	integer	Precision 1