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