PowerCenter
- PowerCenter 10.5.7
- All Products
Informix
| Range
| Transformation
| Range
|
---|---|---|---|
Byte | Minimum is 1 byte. No maximum size. | Binary | 1 to 104,857,600 bytes |
Char(L) | 1 to 32,767 characters | String | 1 to 104,857,600 characters |
Date | Jan 1, 0001 A.D. to Dec 31, 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) |
Datetime year to fraction | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision 21 to 25, scale 1 to 5 (precision to the millisecond) | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Decimal(P,S) | Precision 1 to 32, scale 0 to 32 | Decimal | Precision 1 to 28, scale 0 to 28 |
Float(P) | Precision 1 to 14 | Double | Precision 15 |
Int8 | -9,223,372,036,854,775,807 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 |
Integer | -2,147,483,647 to 2,147,483,647 | Integer | -2,147,483,648 to 2,147,483,647 Precision 10, scale 0 |
Money(P,S) | Precision 1 to 32, scale is 2 | Decimal | Precision 1 to 28, scale 0 to 28 |
Nvarchar | 1 to 255 characters | Nstring | 1 to 104,857,600 characters |
Serial(L) | -2,147,483,647 to 2,147,483,647 | Integer | -2,147,483,648 to 2,147,483,647 Precision 10, scale 0 |
Smallfloat | Precision 1 to 7, scale 0 | Real | Precision 7, scale 0 |
Smallint | -32,767 to 32,767 | Small Integer | Precision 5, scale 0 |
Text | Maximum length is 2e31 | Text | 1 to 104,857,600 characters |
Varchar(M,R) | 1 to 255 characters | String | 1 to 104,857,600 characters |