PowerCenter
- PowerCenter 10.4.0
- 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 |
Blob | 1 to 2,147,483,647 bytes | Binary | 1 to 104,857,600 bytes |
Char(L) | 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 |
Clob | 1 to 2,447,483,647 bytes | Text | 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) |
Dbclob | Up to 1 GB | Ntext | 1 to 104,857,600 characters |
Decimal(P,S) | Precision 1 to 31, scale 0 to 31 | Decimal | Precision 1 to 28, scale 0 to 28 |
Float | Precision 1 to 15 | Double | Precision 15 |
Graphic | 1 to 127 bytes | Nstring | 1 to 104,857,600 characters |
Integer | -2,147,483,648 to 2,147,483,647 | Integer | -2,147,483,648 to 2,147,483,647 Precision 10, scale 0 |
Long Varchar | 1 to 32,700 characters | String | 1 to 104,857,600 characters |
Long Vargraphic | Up to 16,350 bytes | Ntext | 1 to 104,857,600 characters |
Numeric(P,S) | Precision 1 to 31, scale 0 to 31 | Decimal | Precision 1 to 28, scale 0 to 28 |
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 |
Varchar for bit data | Up to 4,000 bytes | Binary | 1 to 104,857,600 bytes |
Vargraphic | Up to 16,336 bytes | String | 1 to 104,857,600 characters |