DB2 for iソースデータ型 | Databricksターゲットデータ型 |
|---|---|
bigint | long |
binary(size), 1 <= size <= 32766 | binary |
char(size) for bit data, 1 <= size <= 32766 | binary |
char(size), 1 <= size <= 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 <= size <= 32740 | binary |
varchar(size), 1 <= size <= 32740 | string |