|
DB2 UDB Source Datatype |
Snowflake Target Datatype |
|---|---|
|
BIGINT |
Number(38,0) |
|
CHAR |
Varchar(1) |
|
CHAR VARYING(p) |
Varchar(p) |
|
CHAR(p) FOR BIT DATA |
Binary(p) |
|
CHAR(p) |
Varchar(p) |
|
DATE |
Date |
|
DECIMAL |
Number(5,0) |
|
DECIMAL(p,s) |
Number(p,s) |
|
DOUBLE PRECISION |
Float |
|
FLOAT |
Float |
|
FLOAT(p) |
Float |
|
GRAPHICS (DB UNICODE ONLY) |
Varchar(2) |
|
GRAPHICS(p) (DB UNICODE ONLY) |
Varchar(p) |
|
INTEGER |
Number(38,0) |
|
NUMERIC |
Number(5,0) |
|
NUMERIC(p,s) |
Number(p,s) |
|
REAL |
Float |
|
SMALLINT |
Number(38,0) |
|
TIME |
Time(9) |
|
TIMESTAMP |
TimeStamp_ntz(9) |
|
VARCHAR(200) FOR BIT DATA |
Binary(8388608) |
|
VARCHAR(p) |
Varchar(p) |
|
VARGRAPHICS(p) (DB UNICODE ONLY) |
Varchar(p) |
The following table shows the DB2 UDB 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 UDB Source Datatype |
Snowflake Target Varchar |
|---|---|
|
Big Int |
Varchar |
|
Date |
Varchar |
|
Decimal |
Varchar |
|
Double |
Varchar |
|
Float |
Varchar |
|
Integer |
Varchar |
|
Numeric |
Varchar |
|
Real |
Varchar |
|
Smallint |
Varchar |
|
Time |
Varchar |
|
Timestamp |
Varchar |