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

前へ次へ

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

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

DB2 for iソースデータ型	Snowflakeターゲットデータ型
bigint	integer
binary(`size`), 1 <= size <= 32766	binary(`size`), 1 <= size <= 32766
char(`size`) for bit data, 1 <= size <= 32766	binary(`size`), 1 <= size <= 32766
char(`size`), 1 <= size <= 32766	char(`size`), 4 <= size <= 131064
date	date
decfloat(`precision`), 16 <= p <= 34	char(255)
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37	number(p,s), 1 <= p <= 38, 0 <= s <= 37
decimal(p,s), 38 <= p <= 63, 0 <= s <= 62	char(`size`), 40 <= size <= 65
float	float
integer	integer
long varbinary	binary
long varchar	varchar
long varchar for bit data	binary
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37	number(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 38 <= p <= 63, 0 <= s <= 62	char(`size`), 40 <= size <= 65
real	float
rowid	binary(40)
smallint	integer
time	time(0)
timestamp(`precision`), 0 <= p <= 9	timestamp_ntz(`precision`), 0 <= p <= 9
timestamp(`precision`), 10 <= p <= 12	char(`size`), 30 <= size <= 32
varbinary(`size`), 1 <= size <= 32740	binary(`size`), 1 <= size <= 32740
varchar(`size`) for bit data, 1 <= size <= 32740	binary(`size`), 1 <= size <= 32740
varchar(`size`), 1 <= size <= 32740	varchar(`size`), 4 <= size <= 130960