XML Guide

10.5.6
- 10.5
- 10.4.0

Back Next

XML and Transformation Datatypes

PowerCenter supports all XML datatypes specified in the W3C May 2, 2001 Recommendation. The following table lists the XML datatypes and compares them to the transformation datatypes in the XML Source Qualifier transformation. For more information about XML datatypes, see the W3C specifications for XML datatypes at http://www.w3.org/TR/xmlschema-2.

You can change the datatypes in XML definitions and in midstream XML transformations if you import an XML file to create the definition. You cannot change XML datatypes when you import them from an XML schema. You cannot change the transformation datatypes for XML sources within a mapping.

The following table describes the XML and corresponding transformation datatypes:

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

Rename Saved Search

Table of Contents

XML Guide

XML Guide

XML and Transformation Datatypes

XML and Transformation Datatypes