Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Db2 for i Source Data Type
| Oracle Target Data Type
|
|---|---|
bigint
| number(19)
|
binary( size ), 1 <= s <= 32766
| blob
|
char( size ) for bit data, 1 <= s <= 32766
| blob
|
char( size ), 1 <= s <= 500
| char(s char), 1 <= s <= 500
|
char( size ), 501 <= s <= 32766
| clob
|
date
| date
|
decfloat( precision ), 16 <= p <= 34
| char(255 char)
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
| number(p,s), 1 <= p <= 38, 0 <= s <= 38
|
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62
| char(s char), 40 <= s <= 65
|
float
| binary_double
|
integer
| number(10)
|
long varbinary
| blob
|
long varchar
| clob
|
long varchar for bit data
| blob
|
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38
| number(p,s), 1 <= p <= 38, 0 <= s <= 38
|
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62
| char(s char), 40 <= s <= 65
|
real
| binary_double
|
rowid
| blob
|
smallint
| number(5)
|
time
| char(8 char)
|
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 <= s <= 32740
| blob
|
varchar( size ) for bit data, 1 <= s <= 32740
| blob
|
varchar( size ), 1 <= s <= 401
| char(s char), 1 <= s <= 401
|
varchar( size ), 501 <= s <= 32740
| clob
|
