DB2 i datatype mapping - 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

DB2 i Source Datatype

Snowflake Target Datatype

BIGINT

Number(38,0)

BLOB

Binary(1048576)

CHAR

Varchar(1)

CHAR FOR BIT DATA

Varchar(1)

CHAR VARYING(p)

Varchar(p)

CHAR(p) FOR BIT DATA

Varchar(p)

CHAR(p)

Varchar(p)

CLOB

Varchar(1048576)

Date

Date

DBCLOB

Varchar(1048576)

DECIMAL(p,s)

Number(p,s)

DECIMAL

Number(5,0)

DOUBLE PRECISION

Float

FLOAT

Float

FLOAT(p)

Float

GRAPHIC(p)

Varchar(p)

INTEGER

Number(38,0)

LONG VARGRAPHIC

Varchar(15966)

NUMERIC

Number(5,0)

NUMERIC(p,s)

Number(p,s)

REAL

Float

SMALLINT

Number(38,0)

TIME

Time(9)

TIMESTAMP

TimeStamp_NTZ(9)

TIMESTAMP(6)

TimeStamp_NTZ(9)

VARCHAR(p) FOR BIT DATA

Varchar(p)

VARCHAR(p)

Varchar(p)

VARGRAPHIC(p)

Varchar(p)

The following table shows the DB2 i source datatypes that are available to map to a varchar target column in a table you create manually on the Snowflake target. If you create the varchar with no precision, by default the size will be 16777216. If you create a fixed-length varchar datatype, ensure this target definition is large enough to accommodate the data sent from the source column.

DB2 i Source Datatype

Snowflake Target Varchar

BIG_INT

Varchar

Date

Varchar

Decimal

Varchar

Double

Varchar

Float

Varchar

Integer

Varchar

Number

Varchar

Real

Varchar

Small Integer

Varchar

Time

Varchar

Timestamp

Varchar