Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Db2 for i Source Data Type | Databricks Delta Target Data Type |
|---|---|
bigint | long |
binary( size ), 1 <= s <= 32766 | binary |
char( size ) for bit data, 1 <= s <= 32766 | binary |
char( size ), 1 <= s <= 32766 | string |
date | string |
decfloat( precision ), 16 <= p <= 34 | string |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62 | string |
float | double |
integer | integer |
long varbinary | binary |
long varchar | string |
long varchar for bit data | binary |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62 | string |
real | float |
rowid | binary |
smallint | integer |
time | string |
timestamp( precision ), 0 <= p <= 6 | timestamp |
timestamp( precision ), 7 <= p <= 12 | string |
varbinary( size ), 1 <= s <= 32740 | binary |
varchar( size ) for bit data, 1 <= s <= 32740 | binary |
varchar( size ), 1 <= s <= 32740 | string |
