DB2 data type | Range and Description | Transformation data type | Range and Description |
|---|---|---|---|
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 |
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 28, scale 0 to 28 |
Double | Precision 15 | Double | Precision 15 |
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 |
Numeric | Precision 1 to 31, scale 0 to 31 | Decimal | Precision 1 to 28, scale 0 to 28 |
Real | Precision 7, scale 0 | Real | Precision 7, scale 0 |
Smallint | -32,768 to 32,767 | Small Integer | Precision 5, scale 0 |
Time | 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 | 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 |