Common Content for Data Integration
- Common Content for Data Integration 10.5.1
- All Products
Datatype
| Range
| Transformation
| Range
|
---|---|---|---|
Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
| Bigint
| -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
|
Char
| 1 to 254 characters
| String
| 1 to 104,857,600 characters
|
Char for bit data
| 1 to 254 bytes
| Binary
| 1 to 104,857,600 bytes
|
Date
| 0001 to 9999 A.D.
Precision 19; scale 0 (precision to the day)
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Decimal
| Precision 1 to 31, scale 0 to 31
| Decimal
| Precision 1 to 31, scale 0 to 31.
|
Float
| Precision 1 to 15
| Double
| Precision 15
|
Integer
| -2,147,483,648 to 2,147,483,647
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
Smallint
| -32,768 to 32,767
| Integer
| -2,147,483,648 to 2,147,483,647
Precision 10, scale 0
|
Time 1
| 24-hour time period
Precision 19, scale 0
(precision to the second)
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Timestamp 2
| 26 bytes
Precision 26, scale 6
(precision to the microsecond)
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
|
Varchar
| Up to 4,000 characters
| String
| 1 to 104,857,600 characters
|
Varchar for bit data
| Up to 4,000 bytes
| Binary
| 1 to 104,857,600 bytes
|
1. When the Data Integration Service converts the DB2 Time data type to the transformation Date/Time data type, the date value is added to the time value.
| |||
2. DB2 for z/OS Version 10 extended-precision timestamps map to transformation datatypes as follows:
|