Informix datatype support - connect_cdc_mimix_share

Informix Source Datatype	Supported Targets
CHAR	DB2 (includes IBM i and UDB) CHAR (Unicode) CLOB (IBM i only) DBCLOB ((IBM i only, Unicode) GRAPHIC (Unicode) VARGRAPHIC (Unicode)
	Informix
	MS SQL Server/SQL Azure
	Oracle VARCHAR2
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

Informix Source Datatype	Supported Targets
DATE	DB2 (includes IBM i and UDB) DATE TIMESTAMP
	Informix DATE DATETIME— Ideal mapping is to DATETIME (YEAR TO DAY). For other target columns, data is padded or truncated to fit the target.
	MS SQL Server/SQL Azure DATE DATETIME—Time generated as all zero's DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME—Time generated as all zero's
	Oracle DATE TIMESTAMP—Time generated as all zero's VARCHAR2
	PostgreSQL DATE TIMESTAMP
	Sybase DATETIME—Time generated as all zero's SMALLDATETIME—Time generated as all zero's
	Teradata DATE LONG VARCHAR TIMESTAMP—Time generated as all zero's TIMESTAMP(P)—Add several timestamps with different precisions
	All platforms CHAR (L) VARCHAR

Informix Source Datatype	Supported Targets
DATETIME	DB2 (includes IBM i and UDB) DATE— If source is at least YEAR TO DAY Distributor truncates time data. TIMESTAMP
	Informix DATE DATETIME—Time generated as all zero's.
	MS SQL Server/SQL Azure DATE DATETIME—Time generated as all zero's. DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME—Time generated as all zero's
	Oracle DATE—Ideal mapping is from DATETIME YEAR TO SECOND. If source is other than that, data is padded or truncated to fit the target; missing date data is generated as current date, missing time as zeros. TIMESTAMP—Time generated as all zero's TIMESTAMP(P) VARCHAR2 (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.
	PostgreSQL DATE TIME TIMESTAMP
	Sybase DATETIME—Time generated as all zero's SMALLDATETIME—Time generated as all
	Teradata DATE LONG VARCHAR TIMESTAMP—Time generated as all zero's TIMESTAMP(P)—Add several timestamps with different precisions
	All Platforms CHAR (L) VARCHAR (L) where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

Informix Source Datatype	Supported Targets
DECIMAL	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) FLOAT INTEGER—Connect CDC Director warns. NUMERIC (p,s) SMALLINT—Connect CDC Director warns.
	Informix DECIMAL (p,s) FLOAT INTEGER—Connect CDC Director warns. MONEY NUMERIC (p,s) SMALLFLOAT SMALLINT—Connect CDC Director warns.
	MS SQL Server/SQL Azure BIGINT BIT—Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER—Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) SMALLINT—Connect CDC Director warns. SMALLMONEY—Assumed tp = 10, ts = 4). TINYINT—Connect CDC Director warns.
	Oracle NUMBER (p,s) NUMBER NUMBER(38) VARCHAR2 (L), where L >= p+2.
DECIMAL	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER. Connect CDC Director warns. MONEY REAL SMALLINT. Connect CDC Director warns.
	Sybase BIT—Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER—Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) SMALLINT—Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT—Connect CDC Director warns.
	Teradata BIGINT BYTEINT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. LONG VARCHAR NUMBER NUMERIC (p,s) SMALLINT—Connect CDC Director warns.
	All Platforms CHAR (L), where L >= p+2. VARCHAR (L), where L >= p+2.
	Note: For all the above, if tp < p, or ts < s, Connect CDC Director issues a warning.

Informix Source Datatype	Supported Targets
DOUBLE PRECISION	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) DOUBLE FLOAT INTEGER REAL
	Informix DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL SMALLFLOAT
	MS SQL Server/SQL Azure BIGINT DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
DOUBLE PRECISION	Oracle DOUBLE PRECISION NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= 22.
	PostgreSQL BIGINT DOUBLE PRECISION REAL
	Sybase DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
	Teradata BIGINT DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER LONG VARCHAR REAL
	All Platforms CHAR (L), where L >= 22. VARCHAR (L), where L >= 22.

Informix Source Datatype	Supported Targets
FLOAT	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) DOUBLE FLOAT INTEGER REAL
	Informix DECIMAL (p,s) DOUBLE PRECISION INTEGER FLOAT REAL SMALLFLOAT
	MS SQL Server/SQL Azure BIGINT DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= 22.
	PostgreSQL BIGINT DECIMAL DOUBLE-PRECISION INTEGER REAL SMALLINT
FLOAT	Sybase DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL
	Teradata BIGINT DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER LONG VARCHAR NUMBER REAL
	All Platforms CHAR (L), where L >= 22. VARCHAR (L), where L >= 22.

Informix Source Datatype	Supported Targets
INTEGER	DB2 (includes IBM i and UDB) BIGINT BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT
	Informix DECIMAL(p,s) FLOAT INTEGER SMALLFLOAT SMALLINT
	MS SQL Server/SQL Azure BIGINT BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT TINYINT
	Oracle NUMBER NUMBER (p,s). Connect CDC Director warns. NUMBER(38) VARCHAR2 (L), where L>= 11.
	PostgreSQL BIGINT DECIMAL DOUBLE INTEGER REAL SMALLINT
INTEGER	Sybase DATETIME—Time generated as all zero's. INTEGER SMALLINT TINYINT
	Teradata BIGINT BYTEINT DECIMAL FLOAT INTEGER LONG VARCHAR NUMBER SMALLINT
	All Platforms CHAR (L), where L>= 11. VARCHAR (L), where L>= 11.

Informix Source Datatype	Supported Targets
INTERVAL (year-to-month format)	DB2 (includes IBM i and UDB) TIME.
	Informix INTERVAL—year-to-month format, defined exactly like the source column.
	MS SQL Server/SQL Azure
	Oracle VARCHAR2 (L), where L >=12.
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR (L), where L >=12. VARCHAR (L), where L >=12.

Informix Source Datatype	Supported Targets
INTERVAL (day-to-fraction format)	DB2 (includes IBM i and UDB) TIME. If source is INTERVAL HOUR TO SECOND. Note: This is a mapping of a span of time to an actual time. Distribution fails if the source column hour value is greater than 23, which does not translate to a valid “clock” time.
	Informix INTERVAL—day-to-fraction format, defined exactly like the source column.
	MS SQL Server/SQL Azure
	Oracle VARCHAR2 (L) where L < 20 receives warning.
	Sybase
	Teradata TIME. If source is INTERVAL HOUR TO SECOND. Note: This is a mapping of a span of time to an actual time. Distribution fails if the source column hour value is greater than 23, which does not translate to a valid “clock” time. LONG VARCHAR
	All Platforms CHAR (L), where L < 20 receives warning. VARCHAR (L), where L < 20 receives warning.

Informix Source Datatype	Supported Targets
MONEY	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. NUMERIC (p,s) SMALLINT. Connect CDC Director warns.
	Informix DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. MONEY NUMERIC (p,s) SMALLFLOAT SMALLINT. Connect CDC Director warns.
	MS SQL Server/SQL Azure BIGINT BIT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) SMALLINT. Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT. Connect CDC Director warns.
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= p+2.
MONEY	PostgreSQL DECIMAL (p,s) MONEY
	Sybase BIT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) SMALLINT. Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT. Connect CDC Director warns.
	Teradata BIGINT BYTEINT. Connect CDC Director warns. DECIMAL (p,s) INTEGER. Connect CDC Director warns. LONG VARCHAR NUMBER NUMERIC (p,s) SMALLINT. Connect CDC Director warns.
	All Platforms CHAR (L), where L >= p+2. VARCHAR (L), where L >= p+2.

Informix Source Datatype	Supported Targets
NCHAR	DB2 (includes IBM i and UDB) CHAR (Unicode)^a DBCLOB ((Unicode IBM i only) GRAPHIC (Unicode)^b VARCHAR (Unicode) VARGRAPHIC (Unicode)^b
	Informix NCHAR NVARCHAR^a
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR^a
	Oracle NCHAR NVARCHAR2
	PostgreSQL CHAR (Unicode type) VARCHAR (Unicode type)
	Sybase
	Teradata CHAR (Unicode type) VARCHAR (Unicode type)

^aOnly if defined in a Unicode database. NCHAR/NVARCHAR columns cannot be mapped to ordinary CHAR/VARCHAR columns.

^bIf tagged with a CCSID that supports a conversion to Unicode.

Informix Source Datatype	Supported Targets
NUMERIC	Functionally equivalent to DECIMAL. See DECIMAL .

Informix Source Datatype	Supported Targets
NVARCHAR	DB2 (includes IBM i and UDB) CHAR (Unicode) ^a DBCLOB ((Unicode IBM i only) GRAPHIC (Unicode) ^b VARCHAR (Unicode) ^a VARGRAPHIC (Unicode) ^b
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR^a
	Oracle NCHAR NVARCHAR2
	PostgreSQL CHAR (Unicode type) VARCHAR (Unicode type)
	Sybase
	Teradata CHAR (Unicode type) VARCHAR (Unicode type)

^aOnly if defined in a Unicode database. NCHAR/NVARCHAR columns cannot be mapped to ordinary CHAR/VARCHAR columns.

^bIf tagged with a CCSID that supports a conversion to Unicode.

Informix Source Datatype	Supported Targets
REAL	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) DOUBLE FLOAT INTEGER REAL
	Informix DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL SMALLFLOAT
	MS SQL Server/SQL Azure DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= 22.
	PostgreSQL DOUBLE-PRECISION REAL
	Sybase BIGINT DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL
REAL	Teradata BIGINT DOUBLE-PRECISION FLOAT INTEGER LONG VARCHAR NUMBER REAL
	All Platforms CHAR (L), where L >= 22. VARCHAR (L), where L >= 22.

Informix Source Datatype	Supported Targets
SERIAL	DB2 (includes IBM i and UDB) INTEGER
	Informix SERIAL
	MS SQL Server/SQL Azure INTEGER
	Oracle INTEGER
	Sybase INTEGER

Informix Source Datatype	Supported Targets
SMALLFLOAT	DB2 (includes IBM i and UDB) DECIMAL (p,s) DOUBLE FLOAT INTEGER REAL
	Informix DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL SMALLFLOAT
	MS SQL Server/SQL Azure DECIMAL (p,s) DOUBLE-PRECISION INTEGER REAL
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= 22.
	PostgreSQL DECIMAL DOUBLE-PRECISION INTEGER REAL SMALLINT
	Sybase DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL
SMALLFLOAT	Teradata DOUBLE-PRECISION FLOAT INTEGER LONG VARCHAR NUMBER REAL
	All Platforms CHAR (L), where L >= 22. VARCHAR (L), where L >= 22.

Informix Source Datatype	Supported Targets
SMALLINT	DB2 (includes IBM i and UDB) BIGINT DECIMAL(p,s) FLOAT INTEGER SMALLINT
	Informix DECIMAL(p,s) FLOAT INTEGER SMALLFLOAT SMALLINT
	MS SQL Server/SQL Azure BIGINT BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT TINYINT
	Oracle NUMBER NUMBER(38) NUMBER (p,s). Connect CDC Director warns VARCHAR2 (L), where L >= 6.
	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER REAL SMALLINT
SMALLINT	Sybase BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT TINYINT
	Teradata BIGINT BIT BYTEINT DECIMAL(p,s) FLOAT INTEGER LONG VARCHAR NUMBER SMALLINT
	All Platforms CHAR (L), where L>= 6. VARCHAR(L), where L>= 6.

Informix Source Datatype	Supported Targets
VARCHAR	DB2 (includes IBM i and UDB) CLOB (IBM i only) DBCLOB (Unicode IBM i only) GRAPHIC (Unicode) VARGRAPHIC (Unicode)
	Informix
	MS SQL Server/SQL Azure TEXT
	Oracle VARCHAR2
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

Informix datatype support - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide