Informix datatype support - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

The following tables show the Informix (as source) datatype support.

 

 

 

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

  • NVARCHARa

 

MS SQL Server/SQL Azure

  • NCHAR

  • NTEXT

  • NVARCHARa

 

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 can­not 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

  • NVARCHARa

 

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 can­not 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