一括取り込みデータベース

前へ次へ

DB2 for iソースとOracleターゲット

次の表は、DB2 for iソースとOracleターゲットを使用した一括取り込みデータベース設定の推奨データ型マッピングを示しています。

DB2 for iソースデータ型	Oracleターゲットデータ型
bigint	number(19)
binary(`size`), 1 <= s <= 2000	raw(`size`), 1 <= size <= 2000
binary(`size`), 2001 <= s <= 32766	blob
char(`size`) for bit data, 1 <= s <= 32766	blob
char(`size`), 1 <= s <= 2000	char(s byte), 1 <= s <= 2000
char(`size`), 2001 <= s <= 4000	varchar2(s byte), 2001 <= s <= 4000
char(`size`), 4001 <= 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 <= size <= 2000	raw(`size`), 1 <= size <= 2000
varbinary(`size`), 2001 <= size <= 32740	blob
varchar(`size`) for bit data, 1 <= size <= 32740	blob
varchar(`size`), 1 <= size <= 4000	varchar2(s byte), 1 <= s <= 4000
varchar(`size`), 4001 <= size <= 32740	clob