PowerCenter
- PowerCenter 10.5
- All Products
Datatype | Transformation | Range |
---|---|---|
anySimpleType | String | 1 to 104,857,600 characters |
anyURI | String | 1 to 104,857,600 characters |
base64Binary | Binary | 1 to 104,857,600 bytes |
boolean | Small Integer | Precision 5; scale 0 |
byte | Small Integer | Precision 5; scale 0 |
date | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
dateTime | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
decimal | Decimal | Precision 1 to 28; scale 0 to 28 |
double | Double | Precision 15, scale 0 |
duration | String | 1 to 104,857,600 characters |
ENTITIES | String | 1 to 104,857,600 characters |
ENTITY | String | 1 to 104,857,600 characters |
float | Double | Precision 15, scale 0 |
gDay | Integer | -2,147,483,648 to 2,147,483,647 Precision 10; scale 0 |
gMonth | Integer | -2,147,483,648 to 2,147,483,647 Precision 10; scale 0 |
gMonthDay | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
gYear | Integer | Precision 10; scale 0 |
gYearMonth | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
hexBinary | Binary | 1 to 104,857,600 bytes |
ID | String | 1 to 104,857,600 characters |
IDREF | String | 1 to 104,857,600 characters |
IDREFS | String | 1 to 104,857,600 characters |
int | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
integer | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
language | String | 1 to 104,857,600 characters |
long | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
Name | String | 1 to 104,857,600 characters |
Ncname | String | 1 to 104,857,600 characters |
negativeInteger | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
NMTOKEN | String | 1 to 104,857,600 characters |
NMTOKENS | String | 1 to 104,857,600 characters |
nonNegativeInteger | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
nonPositiveInteger | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
normalizedString | String | 1 to 104,857,600 characters |
NOTATION | String | 1 to 104,857,600 characters |
positiveInteger | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
QName | String | 1 to 104,857,600 characters |
short | Small Integer | Precision 5; scale 0 |
string | String | 1 to 104,857,600 characters |
time | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
token | String | 1 to 104,857,600 characters |
unsignedByte | Small Integer | Precision 5; scale 0 |
unsignedInt | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
unsignedLong | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19; scale 0 |
unsignedShort | Integer | -2,147,483,648 to 2,147,483,647 Precision 10; scale 0 |