Db2 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 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)