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

前へ次へ

DB2 for iソースとAmazon Redshiftターゲット

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

DB2 for iソースデータ型	Amazon Redshiftターゲットデータ型
bigint	bigint
binary(`size`), 1 <= size <= 32766	binary varying(`size`), 1 <= size <= 32766
char(`size`) for bit data, 1 <= size <= 32766	binary varying(`size`), 1 <= size <= 32766
char(`size`), 1 <= size <= 1024	character(`size`), 4 <= size <= 4096
char(`size`), 1025 <= size <= 32766	character varying(`size`), 4100 <= size <= 65535
date	date
decfloat(`precision`), 16 <= p <= 34	character varying(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37	numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
decimal(p,s), 38 <= p <= 63, 0 <= s <= 62	character varying(`size`), 40 <= size <= 65
float	doubleprecision
integer	integer
long varbinary	binary varying(1024000)
long varchar	character varying(65535)
long varchar for bit data	binary varying(1024000)
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37	numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 63, 0 <= s <= 62	character varying(`size`), 40 <= size <= 65
real	real
rowid	binary varying(40)
smallint	smallint
time	time without time zone
timestamp(`precision`), 0 <= p <= 6	timestamp without time zone
timestamp(`precision`), 7 <= p <= 12	character varying(`size`), 27 <= size <= 32
varbinary(`size`), 1 <= size <= 32740	binary varying(`size`), 1 <= size <= 32740
varchar(`size`) for bit data, 1 <= size <= 32740	binary varying(`size`), 1 <= size <= 32740
varchar(`size`), 1 <= size <= 32740	character varying(`size`), 4 <= size <= 65535