Db2 datatype support - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type: Software
Portfolio: Integrate
Product family: Connect
Product: Connect > Connect CDC (MIMIX Share)
Version: Latest
Language: English
Product name: Connect CDC
Title: Connect CDC System Reference Guide
Copyright: 2024
First publish date: 2003
Last edition: 2024-08-20
Last publish date: 2024-08-20T21:40:14.000381

The following tables show the DB2 (as source) datatype support. This includes IBM i and UDB, unless noted otherwise.

DB2 Source Datatype

Supported Targets

BIGINT (IBM i and UDB)

DB2

BIGINT (only IBM i and UDB)
DECIMAL
FLOAT. Connect CDC Director warns.
INTEGER
NUMERIC
REAL
SMALLINT. Connect CDC Director warns.

Informix

FLOAT. Connect CDC Director warns.
INTEGER
SMALLINT. Connect CDC Director warns.

MS SQL Server/SQL Azure

BIGINT
BIT. Connect CDC Director warns
DECIMAL
FLOAT. Connect CDC Director warns.
INTEGER
MONEY. Connect CDC Director warns.
NUMERIC
REAL
SMALLINT. Connect CDC Director warns.
SMALLMONEY. Connect CDC Director warns.
TINYINT. Connect CDC Director warns.

Oracle

NUMBER (38)
NUMBER (p,s)
VARCHAR2 (L), if L <= 18, Connect CDC Director warns.

PostgreSQL

BIGINT
DECIMAL
DOUBLE PRECISION
INTEGER
REAL
SMALLINT. Connect CDC Director warns.

BIGINT (IBM i and UDB)

Sybase

BIT. Connect CDC Director warns.
DECIMAL
FLOAT. Connect CDC Director warns.
INTEGER
MONEY. Connect CDC Director warns.
SMALLINT. Connect CDC Director warns.
SMALLMONEY. Connect CDC Director warns.
TINYINT. Connect CDC Director warns.

Teradata

BIGINT
BYTEINT. Connect CDC Director warns.
DECIMAL
FLOAT. Connect CDC Director warns.
INTEGER
LONG VARCHAR
NUMBER
NUMERIC
REAL
SMALLINT. Connect CDC Director warns.

All Platforms

CHAR (L)
VARCHAR (L)

if L <= 18, Connect CDC Director warns.

IBM i Source Datatype	Supported Targets
BLOB (IBM i) Binary	IBM i BLOB
	MS SQL Server/SQL Azure IMAGE VARBINARY(MAX)
	Oracle BLOB
	Sybase IMAGE

DB2 Source Datatype	Supported Targets (Defined as Unicode)
CHAR (Unicode)	IBM i CLOB DBCLOB GRAPHIC VARGRAPHIC UDB CHAR GRAPHIC LONG VARCHAR VARCHAR VARGRAPHIC
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX)
	Oracle NCHAR NCLOB NVARCHAR NVARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata CHAR LONG VARCHAR VARCHAR

DB2 Source Datatype	Supported Targets
CHAR	IBM i (Defined as Unicode) CLOB DBCLOB GRAPHIC VARGRAPHIC UDB (Defined as Unicode) GRAPHIC LONG VARCHAR VARGRAPHIC
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX) TEXT
	Oracle CLOB NCLOB NCHAR NTEXT NVARCHAR2 VARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

DB2 Source Datatype	Supported Targets
CHAR FOR BIT DATA (Treat as BINARY)	IBM i BLOB CHAR FOR BIT DATA VARCHAR FOR BIT DATA UDB CHAR FOR BIT DATA VARCHAR FOR BIT DATA
	Informix
	MS SQL Server/SQL Azure BINARY IMAGE VARBINARY VARBINARY(MAX)
	Oracle BLOB LONG RAW RAW
	PostgreSQL BYTEA
	Sybase BINARY IMAGE VARBINARY

DB2 Source Datatype	Supported Targets (Can be Unicode or Non-Unicode)
CHAR FOR BIT (Treat as CHARACTER)	IBM i CLOB. (Unicode or non-Unicode) DBCLOB. (Unicode) GRAPHIC. (Unicode) VARGRAPHIC. (Unicode) UDB GRAPHIC. (Unicode) VARGRAPHIC. (Unicode)
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX) TEXT
	Oracle CLOB NCLOB NCHAR NTEXT NVARCHAR2 VARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

IBM i Source Datatype	Supported Targets
CLOB (IBM i)	IBM i CLOB DBCLOB
	MS SQL Server/SQL Azure NTEXT NVARCHAR(MAX) TEXT VARCHAR(MAX)
	Oracle CLOB NCLOB
	PostgreSQL TEXT
	Sybase TEXT

DB2 Source Datatype	Supported Targets
DATE	DB2 (includes IBM i and UDB) DATE
	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 (L), where L >= 8. Format of target value is YYYYMMDD.
	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 (L)* where L >= 8. Format of target value is YYYYMMDD.

IBM i Source Datatype	Supported Targets (Defined as Unicode)
DBCLOB (Unicode)	IBM i DBCLOB GRAPHIC VARGRAPHIC
	MS SQL Server/SQL Azure NTEXT NVARCHAR(MAX)
	Oracle NCLOB
	Teradata CHAR LONG VARCHAR VARCHAR

IBM i Source Datatype	Supported Targets (Can be Unicode or Non-Unicode)
DBCLOB	IBM i DBCLOB GRAPHIC VARGRAPHIC
	MS SQL Server/SQL Azure NTEXT NVARCHAR(MAX)
	Oracle NCLOB
	Teradata CHAR LONG VARCHAR VARCHAR

DB2 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.

DB2 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
	Oracle DOUBLE PRECISION NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2
	PostgreSQL DOUBLE PRECISION REAL
	Sybase DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
DOUBLE PRECISION	Teradata BIGINT DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER LONG VARCHAR REAL
	All Platforms CHAR VARCHAR

DB2 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
	PostgreSQL BIGINT DECIMAL DOUBLE-PRECISION INTEGER REAL
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 VARCHAR

DB2 Source Datatype	Supported Targets
GRAPHIC (Unicode)	UDB (Defined as Unicode) CHAR GRAPHIC VARCHAR VARGRAPHIC IBM I (Defined as Unicode) CHAR DBCLOB GRAPHIC VARGRAPHIC
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX)
	Oracle NCHAR NCLOB NVARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata CHAR. (Unicode) LONG VARCHAR. (Unicode) VARCHAR. (Unicode)

DB2 Source Datatype	Supported Targets
GRAPHIC	IBM I CHAR. (Unicode) DBCLOB. (Can be Unicode or Non-Unicode) GRAPHIC. (Can be Unicode or Non-Unicode) VARGRAPHIC. (Can be Unicode or Non-Unicode) UDB CHAR. (Unicode) GRAPHIC. (Can be Unicode or Non-Unicode) VARCHAR. (Unicode) VARGRAPHIC. (Can be Unicode or Non-Unicode)
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX)
	Oracle NCHAR NCLOB NVARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata CHAR. (Unicode) LONG VARCHAR. (Unicode) VARCHAR. (Unicode)

DB2 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 PRECISION INTEGER REAL
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.

DB2 Source Datatype	Supported Targets (Defined as Unicode)
LONG VARCHAR (Unicode) Note: IBM has deprecated LONG VARCHAR, use VARCHAR instead	IBM i CLOB DBCLOB GRAPHIC VARGRAPHIC UDB CHAR LONG VARCHAR VARCHAR
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX)
	Oracle NCHAR NCLOB NVARCHAR NVARCHAR2
	Sybase
	Teradata CHAR LONG VARCHAR VARCHAR

DB2 Source Datatype	Supported Targets (Can be Unicode or Non-Unicode)
LONG VARCHAR Note: IBM has deprecated LONG VARCHAR, use VARCHAR instead	IBM i CLOB DBCLOB GRAPHIC VARGRAPHIC
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX) TEXT
	Oracle CLOB NCLOB NCHAR NTEXT NVARCHAR2 VARCHAR2
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

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

DB2 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
	PostgreSQL BIGINT DOUBLE-PRECISION INTEGER 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 VARCHAR

DB2 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.

DB2 Source Datatype	Supported Targets
TIME	DB2 (includes IBM i and UDB) TIME TIMESTAMP. Truncate Date
	Informix DATETIME. Truncate Date
	MS SQL Server/SQL Azure DATETIME. Truncate Date DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME. Truncate Date TIME TIME(P)
	Oracle DATE. Truncate Date TIMESTAMP. Truncate Date TIMESTAMP (P) VARCHAR2. Format of target value is HHMMSS.
	PostgreSQL TIME TIMESTAMP
	Sybase DATETIME. Truncate Date SMALLDATETIME. Truncate Date
	Teradata LONG VARCHAR(13) TIME TIME(P) TIMESTAMP. Truncate Date TIMESTAMP (P) TIMESTAMP(P). Truncate Date
	All Platforms CHAR. Format of target value is HHMMSS. VARCHAR. Format of target value is HHMMSS.

DB2 Source Datatype	Supported Targets
TIMESTAMP	DB2 (includes IBM i and UDB) CHAR TIMESTAMP
	Informix DATETIME. Ideal mapping is to DATETIME (YEAR TO SECOND). For other target columns, data is padded or truncated to fit the target.
	MS SQL Server/SQL Azure DATETIME. Last 3 fractions of a second are truncated. DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME. Seconds and fractions of a second of time data are truncated.
	Oracle TIMESTAMP VARCHAR2 (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.
	PostgreSQL TIME TIMESTAMP
	Sybase DATETIME. Last 3 fractions of a second are truncated. SMALLDATETIME. Seconds and fractions of a second of time data are truncated.
	Teradata TIMESTAMP LONG VARCHAR (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.
	All Platforms CHAR (L) VARCHAR (L) where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

DB2 Source Datatype	Supported Targets (Can be Unicode or Non-Unicode)
VARCHAR	IBM i CLOB DBCLOB GRAPHIC VARGRAPHIC UDB GRAPHIC. VARGRAPHIC
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX) TEXT
	Oracle CLOB NCLOB NCHAR NTEXT NVARCHAR2 VARCHAR2
	PostgreSQL VARCHAR TEXT
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

DB2 Source Datatype	Supported Targets
VARCHAR For BIT (Treat as BINARY)	IBM i BLOB CHAR FOR BIT DATA VARCHAR FOR BIT DATA UDB CHAR FOR BIT DATA VARCHAR FOR BIT DATA
	Informix
	MS SQL Server/SQL Azure BINARY IMAGE VARBINARY VARBINARY(MAX)
	Oracle BLOB LONG RAW RAW
	PostgreSQL BYTEA
	Sybase BINARY IMAGE VARBINARY

DB2 Source Datatype	Supported Targets (Can be Unicode or Non-Unicode)
VARCHAR FOR BIT (Treat as CHARACTER)	IBM i CLOB. (Unicode or non-Unicode) DBCLOB. (Unicode) GRAPHIC. (Unicode) VARGRAPHIC. (Unicode) UDB GRAPHIC. (Unicode) VARGRAPHIC. (Unicode)
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX) TEXT
	Oracle CLOB NCLOB NCHAR NTEXT NVARCHAR2 VARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

DB2 Source Datatype	Supported Targets
VARGRAPHIC (Unicode)	UDB (Defined as Unicode) CHAR GRAPHIC VARCHAR VARGRAPHIC IBM I (Defined as Unicode) CHAR CLOB DBCLOB GRAPHIC VARGRAPHIC
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX)
	Oracle NCHAR NCLOB NVARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata CHAR. (Unicode) LONG VARCHAR. (Unicode) VARCHAR. (Unicode)

DB2 Source Datatype	Supported Targets
VARGRAPHIC	IBM I CHAR. (Unicode) DBCLOB. (Can be Unicode or Non-Unicode) GRAPHIC. (Can be Unicode or Non-Unicode) VARGRAPHIC. (Can be Unicode or Non-Unicode) UDB CHAR. (Unicode) GRAPHIC. (Can be Unicode or Non-Unicode) VARCHAR. (Unicode) VARGRAPHIC. (Can be Unicode or Non-Unicode)
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR NVARCHAR(MAX)
	Oracle NCHAR NCLOB NVARCHAR2
	PostgreSQL CHAR TEXT VARCHAR
	Sybase
	Teradata CHAR. (Unicode) LONG VARCHAR. (Unicode) VARCHAR. (Unicode)