Mass Ingestion
- Mass Ingestion
- 所有产品
DB2 for LUWソースデータ型
| Oracleターゲットデータ型
|
---|---|
bigint
| number(19)
|
binary( size ), 1 <= size <= 255
| raw( size ), 1 <= size <= 255
|
boolean
| char(1 char)
|
char for bit data
| raw(1)
|
char( size ) for bit data, 2 <= size <= 255
| raw( size ), 2 <= size <= 255
|
character( size ), 1 <= size <= 255
| varchar2(s byte), 1 <= s <= 255
|
date
| date
|
decfloat( precision ), 16 <= p <= 34
| varchar2(255 char)
|
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31
| number(p,s), 1 <= p <= 31, 0 <= s <= 31
|
double
| binary_double
|
integer
| number(10)
|
long varchar
| clob
|
long varchar for bit data
| blob
|
real
| binary_float
|
smallint
| number(5)
|
time
| timestamp(0)
|
timestamp(0)
| date
|
timestamp( precision ), 1 <= p <= 9
| timestamp( precision ), 1 <= p <= 9
|
timestamp( precision ), 10 <= p <= 12
| char(s char), 30 <= s <= 32
|
varbinary( size ), 1 <= size <= 1501
| raw( size ), 1 <= size <= 1501
|
varbinary( size ), 2001 <= size <= 32672
| blob
|
varchar( size ) for bit data, 1 <= size <= 1501
| raw( size ), 1 <= size <= 1501
|
varchar( size ) for bit data, 2001 <= size <= 32672
| blob
|
varchar( size ), 1 <= size <= 3501
| varchar2(s byte), 1 <= s <= 3501
|
varchar( size ), 4001 <= size <= 32672
| clob
|