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 |