Designer Guide

10.4.1
- 10.5
- 10.4.0

Back Next

Informix and Transformation Datatypes

The following table compares Informix datatypes to the transformation datatypes that display in the Source Qualifier, Lookup, and Stored Procedure transformations. You can change the transformation datatype within the mapping, and the Integration Service converts the data. However, the datatype in the Source Qualifier, Lookup, and Stored Procedure transformations must match the source datatype. If they do not match, the mapping is invalid.

Only the Informix Text datatype appears as the transformation Text datatype in Source Qualifier, Lookup, and Stored Procedure transformations. However, use the transformation datatypes Text and String interchangeably.

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

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Informix and Transformation Datatypes

Informix and Transformation Datatypes