Db2 for IBM i datatype support - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

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.

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.

All Platforms

• CHAR (L)

• VARCHAR (L)

if L <= 18, Connect CDC Director warns.

BLOB (IBM i) Binary

IBM i

• BLOB

MS SQL Server/SQL Azure

• IMAGE

• VARBINARY(MAX)

Oracle

• BLOB

CHAR (Unicode)

IBM i

• CLOB

• DBCLOB

• GRAPHIC

• VARGRAPHIC

UDB

• CHAR

• GRAPHIC

• LONG VARCHAR

• VARCHAR

• VARGRAPHIC

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

Oracle

• NCHAR

• NCLOB

• NVARCHAR

• NVARCHAR2

CHAR

IBM i (Defined as Unicode)

• CLOB

• DBCLOB

• GRAPHIC

• VARGRAPHIC

UDB (Defined as Unicode)

• GRAPHIC

• LONG VARCHAR

• VARGRAPHIC

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

• TEXT

Oracle

• CLOB

• NCLOB

• NCHAR

• NTEXT

• NVARCHAR2

• VARCHAR2

PostgreSQL

• CHAR

• TEXT

• VARCHAR

All Platforms

• CHAR

• VARCHAR

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

MS SQL Server/SQL Azure

• BINARY

• IMAGE

• VARBINARY

• VARBINARY(MAX)

Oracle

• BLOB

• LONG RAW

• RAW

PostgreSQL

• BYTEA

CHAR FOR BIT (Treat as CHARACTER)

IBM i

• CLOB. (Unicode or non-Unicode)

• DBCLOB. (Unicode)

• GRAPHIC. (Unicode)

• VARGRAPHIC. (Unicode)

UDB

• GRAPHIC. (Unicode)

• VARGRAPHIC. (Unicode)

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

• TEXT

Oracle

• CLOB

• NCLOB

• NCHAR

• NTEXT

• NVARCHAR2

• VARCHAR2

PostgreSQL

• CHAR

• TEXT

• VARCHAR

All Platforms

• CHAR

• VARCHAR

CLOB (IBM i)

IBM i

• CLOB

• DBCLOB

MS SQL Server/SQL Azure

• NTEXT

• NVARCHAR(MAX)

• TEXT

• VARCHAR(MAX)

Oracle

• CLOB

• NCLOB

PostgreSQL

• TEXT

DATE

Db2 (includes IBM i and UDB)

• DATE

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.

All Platforms

• CHAR (L)

• VARCHAR (L)*

where L >= 8. Format of target value is YYYYMMDD.

DBCLOB (Unicode)

IBM i

• DBCLOB

• GRAPHIC

• VARGRAPHIC

MS SQL Server/SQL Azure

• NTEXT

• NVARCHAR(MAX)

Oracle

• NCLOB

DBCLOB

IBM i

• DBCLOB

• GRAPHIC

• VARGRAPHIC

MS SQL Server/SQL Azure

• NTEXT

• NVARCHAR(MAX)

Oracle

• NCLOB

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.

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.

PostgreSQL

• BIGINT

• DECIMAL

• DOUBLE PRECISION

• INTEGER. Connect CDC Director warns.

• MONEY

• REAL

• SMALLINT. Connect CDC Director warns.

All Platforms

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

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

DOUBLE PRECISION

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• DOUBLE

• FLOAT

• INTEGER

• REAL

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

All Platforms

• CHAR

• VARCHAR

FLOAT

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• DOUBLE

• FLOAT

• INTEGER

• REAL

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

All Platforms

• CHAR

• VARCHAR

GRAPHIC (Unicode)

UDB (Defined as Unicode)

• CHAR

• GRAPHIC

• VARCHAR

• VARGRAPHIC

IBM i (Defined as Unicode)

• CHAR

• DBCLOB

• GRAPHIC

• VARGRAPHIC

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

Oracle

• NCHAR

• NCLOB

• NVARCHAR2

PostgreSQL

• CHAR

• TEXT

• VARCHAR

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)

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

Oracle

• NCHAR

• NCLOB

• NVARCHAR2

PostgreSQL

• CHAR

• TEXT

• VARCHAR

INTEGER

Db2 (includes IBM i and UDB)

• BIGINT

• BIT

• DECIMAL(p,s)

• FLOAT

• INTEGER

• 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

All Platforms

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

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

IBM i

• CLOB

• DBCLOB

• GRAPHIC

• VARGRAPHIC

UDB

• CHAR

• LONG VARCHAR

• VARCHAR

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

Oracle

• NCHAR

• NCLOB

• NVARCHAR

• NVARCHAR2

IBM i

• CLOB

• DBCLOB

• GRAPHIC

• VARGRAPHIC

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

• TEXT

Oracle

• CLOB

• NCLOB

• NCHAR

• NTEXT

• NVARCHAR2

• VARCHAR2

All Platforms

• CHAR

• VARCHAR

NUMERIC

Functionally equivalent to DECIMAL. See DECIMAL.

REAL

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• DOUBLE

• FLOAT

• INTEGER

• REAL

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

All Platforms

• CHAR

• VARCHAR

SMALLINT

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL(p,s)

• FLOAT

• INTEGER

• 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

All Platforms

• CHAR (L), where L>= 6.

• VARCHAR (L), where L>= 6.

TIME

Db2 (includes IBM i and UDB)

• TIME

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

All Platforms

• CHAR. Format of target value is HHMMSS.

• VARCHAR. Format of target value is HHMMSS.

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

All Platforms

• CHAR (L)

• VARCHAR (L)

where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

VARCHAR

IBM i

• CLOB

• DBCLOB

• GRAPHIC

• VARGRAPHIC

UDB

• GRAPHIC.

• VARGRAPHIC

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

• TEXT

Oracle

• CLOB

• NCLOB

• NCHAR

• NTEXT

• NVARCHAR2

• VARCHAR2

PostgreSQL

• VARCHAR

• TEXT

All Platforms

• CHAR

• VARCHAR

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

MS SQL Server/SQL Azure

• BINARY

• IMAGE

• VARBINARY

• VARBINARY(MAX)

Oracle

• BLOB

• LONG RAW

• RAW

PostgreSQL

• BYTEA

VARCHAR FOR BIT (Treat as CHARACTER)

IBM i

• CLOB. (Unicode or non-Unicode)

• DBCLOB. (Unicode)

• GRAPHIC. (Unicode)

• VARGRAPHIC. (Unicode)

UDB

• GRAPHIC. (Unicode)

• VARGRAPHIC. (Unicode)

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

• TEXT

Oracle

• CLOB

• NCLOB

• NCHAR

• NTEXT

• NVARCHAR2

• VARCHAR2

PostgreSQL

• CHAR

• TEXT

• VARCHAR

All Platforms

• CHAR

• VARCHAR

VARGRAPHIC (Unicode)

UDB (Defined as Unicode)

• CHAR

• GRAPHIC

• VARCHAR

• VARGRAPHIC

IBM i (Defined as Unicode)

• CHAR

• CLOB

• DBCLOB

• GRAPHIC

• VARGRAPHIC

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

Oracle

• NCHAR

• NCLOB

• NVARCHAR2

PostgreSQL

• CHAR

• TEXT

• VARCHAR

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)

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR

• NVARCHAR(MAX)

Oracle

• NCHAR

• NCLOB

• NVARCHAR2

PostgreSQL

• CHAR

• TEXT

• VARCHAR