Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Db2 for zOS Source Data Type | Snowflake Target Data Type |
|---|---|
bigint | integer |
binary( size ), 1 <= s <= 255 | binary( size ), 1 <= s <= 255 |
char for bit data | binary(1) |
char( size ) for bit data, 2 <= s <= 255 | binary( size ), 2 <= s <= 255 |
char( size ), 1 <= s <= 255 | char( size ), 4 <= s <= 1020 |
date | date |
decfloat( precision ), 16 <= p <= 34 | char(255) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | number(p,s), 1 <= p <= 31, 0 <= s <= 31 |
float | float |
integer | integer |
long varchar | varchar(130816) |
long varchar for bit data | binary(32704) |
real | float |
rowid | binary(40) |
smallint | integer |
time | time(0) |
timestamp( precision ) with time zone, 0 <= p <= 9 | timestamp_tz( precision ), 0 <= p <= 9 |
timestamp( precision ) with time zone, 10 <= p <= 12 | char( size ), 70 <= s <= 72 |
timestamp( precision ), 0 <= p <= 9 | timestamp_ntz( precision ), 0 <= p <= 9 |
timestamp( precision ), 10 <= p <= 12 | char( size ), 30 <= s <= 32 |
varbinary( size ), 1 <= s <= 32704 | binary( size ), 1 <= s <= 32704 |
varchar( size ) for bit data, 1 <= s <= 32704 | binary( size ), 1 <= s <= 32704 |
varchar( size ), 1 <= s <= 32704 | varchar( size ), 4 <= s <= 130816 |
