Db2 for z/OS Source Data Type | Microsoft SQL Server Target Data Type |
|---|---|
bigint | bigint |
binary(p), 1 <= p <= 255 | varbinary(p), 1 <= p <= 255 |
char(p) for bit data, 1<= p <= 255 | varbinary(p), 1 <= p <= 255 |
char(p), 1 <= size <= 255 | varchar(p), 1 <= p <= 255 |
date | date |
decfloat(p), 16 <= p <= 34 | varchar(255) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 |
float | float |
integer | int |
long varchar | varchar(max) |
long varchar for bit data | geography |
real | real |
rowid | varbinary(40) |
smallint | smallint |
time | time(0) |
timestamp(p) with time zone, 0 <= p <= 7 | datetimeoffset(p), 0 <= p <= 7 |
timestamp(p) with time zone, 8 <= p <= 12 | char(p), 68 <= p <= 72 |
timestamp(p), 0 <= p <= 7 | datetime2(p), 0 <= p <= 7 |
timestamp(p), 8 <= p <= 12 | char(p), 28 <= p <= 32 |
varbinary(p), 1 <= size <= 32704 | varbinary(p), 1 <= p <= max |
varchar(p) for bit data, 1 <= size <= 32704 | varbinary(p), 1 <= p <= max |
varchar(p), 1 <= size <= 32704 | varchar(p), 1 <= p <= max |