Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Db2 for i Source Data Type | Amazon Redshift Target Data Type |
|---|---|
bigint | bigint |
binary( size ), 1 <= s <= 32766 | character varying( size ), 2 <= s <= 65532 |
char( size ) for bit data, 1 <= s <= 32766 | character varying( size ), 2 <= s <= 65532 |
char( size ), 1 <= s <= 32766 | character varying( size ), 4 <= s <= 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, 1 <= s <= 62 | character varying( size ), 40 <= s <= 65 |
float | double precision |
integer | integer |
long varbinary | character varying(65535) |
long varchar | character varying(65535) |
long varchar for bit data | character varying(65535) |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 37 | numeric(p,s), 1 <= p <= 38, 0 <= s <= 37 |
numeric(p,s), 38 <= p <= 63, 1 <= s <= 62 | character varying( size ), 40 <= s <= 65 |
real | real |
rowid | character varying(80) |
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 <= s <= 32 |
varbinary( size ), 1 <= s <= 32740 | character varying( size ), 2 <= s <= 65480 |
varchar( size ) for bit data, 1 <= s <= 32740 | character varying( size ), 2 <= s <= 65480 |
varchar( size ), 1 <= s <= 32740 | character varying( size ), 4 <= s <= 65535 |
