Teradata datatype support - connect_cdc_mimix_share - Latest

BIGINT

DB2 (includes IBM i and UDB)

• BIGINT

• DECIMAL

• FLOAT

• INTEGER

• NUMERIC

• REAL

• SMALLINT

Informix

• FLOAT

• INTEGER

• SMALLINT

MS SQL Server

• BIGINT

• BIT

• DECIMAL

• FLOAT

• INTEGER

• MONEY

• NUMERIC

• REAL

• SMALLINT

• SMALLMONEY

• TINYINT

Oracle

• NUMBER (38)

• NUMBER (p,s)

• VARCHAR2 (L), if L <= 18, Connect CDC Director warns.

Sybase

• BIT

• DECIMAL

• FLOAT

• INTEGER

• SMALLINT

• TINYINT

All platforms

• CHAR (L)

• VARCHAR (L)

if L <= 18, Connect CDC Director warns.

*Oracle recommends VARCHAR2.

BYTEINT

DB2 (includes IBM i and UDB)

• BIGINT

• DECIMAL

• FLOAT

• INTEGER

• NUMERIC

• REAL

• SMALLINT

Informix

• FLOAT

• INTEGER

• SMALLINT

MS SQL Server

• BIGINT

• BIT

• DECIMAL

• FLOAT

• INTEGER

• MONEY

• NUMERIC

• REAL

• SMALLINT

• SMALLMONEY

• TINYINT

Oracle

• NUMBER (38)

• NUMBER (p,s)

• VARCHAR2 (L), if L <= 18, Connect CDC Director warns.

Sybase

• BIT

• DECIMAL

• FLOAT

• INTEGER

• SMALLINT

• TINYINT

CHAR

DB2 (includes IBM i and UDB)

• BIGINT (only IBM i and UDB)

• CHAR

• DATE

• DECIMAL

• DOUBLE

• FLOAT

• INTEGER

• NUMERIC

• REAL

• SMALLINT

• TIME

• TIMESTAM

• VARCHAR

Informix

• CHAR

• DATE

• DATETIME

• DECIMAL

• DOUBLE PRECISION

• FLOAT

• INTEGER

• INTERVAL

• MONEY

• NUMERIC

• REAL

• SERIAL

• SMALLFLOAT

• SMALLINT

• VARCHAR

CHAR

MS SQL Server

• BIGINT

• BIT

• CHAR

• DATE

• DATETIME

• DATETIME2(P)

• DATETIMEOFFSET(P)

• DECIMAL

• DOUBLE PRECISION

• FLOAT

• INTEGER

• MONEY

• NUMERIC

• REAL

• SMALLDATETIME

• SMALLINT

• SMALLMONEY

• TEXT

• TIME

• TIME(P)

• TINYINT

• VARCHAR

• VARCHAR (MAX)

CHAR

Oracle

• CHAR

• CLOB

• DATE

• DECIMAL

• DOUBLE PRECISION

• FLOAT

• INTEGER

• LONG

• LONG RAW

• NUMBER

• NUMERIC

• REAL

• SMALLINT

• TIMESTAMP

• TIMESTAMP(P)

• VARCHAR

• VARCHAR2

Sybase

• BIT

• CHAR

• DATETIME

• DECIMAL

• DOUBLE PRECISION

• FLOAT

• INTEGER

• MONEY

• NUMERIC

• REAL

• SMALLDATETIME

• SMALLINT

• SMALLMONEY

• TEXT

• TIME

• TINYINT

• VARCHAR

DATE

DB2 (includes IBM i and UDB)

• DATE

• TIMESTAMP. Time generated as all zero's.

Informix

• DATE

• DATETIME. Ideal mapping is to DATETIME (YEAR TO DAY). For other target columns, data is padded or truncated to fit the target. Time generated as all zero's.

MS SQL Server

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

Sybase

• DATETIME. Time generated as all zero's.

• SMALLDATETIME. Time generated as all zero's.

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

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

DECIMAL

Oracle

• NUMBER (p,s)

• NUMBER

• NUMBER(38)

• VARCHAR2 (L), where L >= p+2.

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.

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

• BIGINT

• DECIMAL (p,s)

• DOUBLE PRECISION

• FLOAT

• INTEGER

• REAL

Oracle

• DOUBLE PRECISION

• NUMBER

• NUMBER (p,s)

• NUMBER(38)

• VARCHAR2 (L), where L >= 22.

Sybase

• DECIMAL (p,s)

• DOUBLE PRECISION

• FLOAT

• INTEGER

• REAL

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

• BIGINT

• DECIMAL (p,s)

• DOUBLE PRECISION

• FLOAT

• INTEGER

• REAL

Oracle

• NUMBER

• NUMBER (p,s)

• NUMBER(38)

• VARCHAR2 (L), where L >= 22.

Sybase

• DECIMAL (p,s)

• DOUBLE PRECISION

• FLOAT

• INTEGER

• REAL

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

• BIGINT

• BIT

• DECIMAL (p,s)

• FLOAT

• INTEGER

• SMALLINT

• TINYINT

Oracle

• NUMBER

• NUMBER (p,s)

• NUMBER(38)

• VARCHAR2 (L), where L>= 11.

Sybase

• DATETIME. Time generated as all zero's.

• INTEGER

• SMALLINT

• TINYINT

LONG VARCHAR

• Functionally equivalent to DECIMAL. See CHAR .

NUMBER

DB2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• FLOAT

• INTEGER

• NUMERIC (p,s)

• REAL

• SMALLINT

Informix

• DECIMAL (p,s)

• FLOAT

• INTEGER

• MONEY

• NUMERIC (p,s)

• REAL

• SMALLFLOAT

• SMALLINT

MS SQL Server

• BIGINT

• BIT

• DECIMAL

• FLOAT

• INTEGER

• MONEY

• NUMERIC

• REAL

• SMALLINT

• SMALLMONEY

• TINYINT

NUMBER

Oracle

• DECIMAL

• FLOAT

• INTEGER

• NUMBER

• NUMBER (38)

• NUMBER (p,s)

• NUMERIC

• REAL

• SMALLINT

Sybase

• BIT

• DECIMAL (p,s)

• FLOAT

• INTEGER

• MONEY

• NUMERIC

• REAL

• SMALLINT

• SMALLMONEY

• TINYINT

NUMERIC

• Functionally equivalent to DECIMAL. See DECIMAL .

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

• DECIMAL (p,s)

• DOUBLE PRECISION

• FLOAT

• INTEGER

• REAL

Oracle

• NUMBER

• NUMBER (p,s)

• NUMBER(38)

• VARCHAR2 (L), where L >= 22.

Sybase

• DECIMAL (p,s)

• DOUBLE PRECISION

• FLOAT

• INTEGER

• REAL

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

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

Sybase

• DATETIME. Time generated as all zero's.

• INTEGER

• SMALLINT

• TINYINT

TIME(P)

DB2 (includes IBM i and UDB)

• TIME

• TIMESTAMP

Informix

• DATETIME

MS SQL Server

• DATETIME

• DATETIME2(P)

• DATETIMEOFFSET(P)

• SMALLDATETIME

• TIME

• TIME(P)

Oracle

• TIMESTAMP

• TIMESTAMP (P)

Sybase

• DATETIME

• SMALLDATETIME

TIMESTAMP

DB2 (includes IBM i and UDB)

• DATE

• TIME

• TIMESTAMP

Informix

• DATE

• DATETIME

MS SQL Server

• DATE

• DATETIME

• DATETIME2(P)

• DATETIMEOFFSET(P)

• SMALLDATETIME

• TIME

• TIME(P)

Oracle

• DATE

• TIMESTAMP

• TIMESTAMP (P)

Sybase

• DATETIME

• SMALLDATETIME

TIMESTAMP (P)

DB2 (includes IBM i and UDB)

• DATE

• TIME

• TIMESTAMP

Informix

• DATE

• DATETIME

MS SQL Server

• DATE

• DATETIME

• DATETIME2(P)

• DATETIMEOFFSET(P)

• SMALLDATETIME

• TIME

• TIME(P)

Oracle

• DATE

• TIMESTAMP

• TIMESTAMP (P)

Sybase

• DATETIME

• SMALLDATETIME

VARCHAR

• Functionally equivalent to CHAR. See CHAR .