Db2 Warehouse on Cloud Connector > Data Type Reference > Db2 Warehouse on Cloud and Transformation Data Types
  

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