Db2 for i Source Data Type | Microsoft SQL Server Target Data Type |
|---|---|
bigint | bigint |
binary(size), 1 <= size <= 8000 | varbinary(n), 1 <= n <= 8000 |
binary(size), 8001 <= size <= 32766 | varbinary(max) |
char(size) for bit data, 1 <= size <= 8000 | varbinary(n), 1 <=n <= 8000 |
char(size) for bit data, 8001 <= size <= 32766 | varbinary(max) |
char(size), 1 <= size <= 8000 | varchar(n), 1 <= n <= 8000 |
char(size), 8001 <= size <= 32766 | varchar(max) |
date | date |
decfloat(precision), 16 <= p <= 34 | varchar(255) |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
decimal(p,s), 39 <= p <= 63, 0 <= s <= 62 | char(n), 40 <= n <= 65 |
float | float |
integer | int |
long varbinary | varbinary(max) |
long varchar | varchar(max) |
long varchar for bit data | varbinary(max) |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
numeric(p,s), 39 <= p <= 63, 0 <= s <= 62 | char(n), 40 <= n <= 65 |
real | real |
rowid | varbinary(40) |
smallint | smallint |
time | time(0) |
timestamp(precision), 0 <= p <= 7 | datetime2(precision), 0 <= p <= 7 |
timestamp(precision), 8 <= p <= 12 | char(n), 28 <= n <= 32 |
varbinary(size), 1 <= size <= 32740 | varbinary(n), 1 <= n <= max |
varchar(size) for bit data, 1 <= size <= 32740 | varbinary(n), 1 <= n <= max |
varchar(size), 1 <= size <= 32740 | varchar(n), 1 <= n <= max |