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

前へ次へ

DB2 for z/OSソースとOracleターゲット

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

DB2 for z/OSソースデータ型	Oracleターゲットデータ型
bigint	number(19)
binary(`size`), 1 <= size <= 255	raw(`size`), 1 <= size <= 255
char for bit data	blob
char(`size`) for bit data, 2 <= size <= 255	blob
char(`size`), 1 <= size <= 255	char(s byte), 1 <= s <= 255
date	date
decfloat(`precision`), 16 <= p <= 34	char(255 char)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31	number(p,s), 1 <= p <= 31, 0 <= s <= 31
float	binary_double
integer	number(10)
long varchar	clob
long varchar for bit data	blob
real	binary_double
rowid	blob
smallint	number(5)
time	char(8 char)
timestamp(0)	date
timestamp(`precision`) with time zone, 0 <= p <= 9	timestamp(`precision`) with time zone, 0 <= p <= 9
timestamp(`precision`) with time zone, 10 <= p <= 12	char(s char), 70 <= s <= 72
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 <= 32704	blob
varchar(`size`) for bit data, 1 <= size <= 32704	blob
varchar(`size`), 1 <= size <= 3501	varchar2(s byte), 1 <= s <= 3501
varchar(`size`), 4001 <= size <= 32704	clob