IBM DB2/MVS subscriptions to Microsoft® SQL Server™ 2000 publications are supported through the OLE DB provider and ODBC driver that are included with Microsoft Host Integration Server 2000.
The following table maps SQL Server 2000 data types to IBM DB2/MVS data types. When you replicate to OLE DB or ODBC Subscribers, the distribution task maps SQL Server 2000 data types to the closest data type on the target database.
| SQL Server 2000 data type | DB2/MVS data type |
|---|---|
| binary(n) | CHAR(254) FOR BIT DATA NOT NULL |
| bit | SMALLINT |
| char(n) | CHAR (254) NOT NULL |
| datetime | TIMESTAMP NOT NULL |
| decimal | DECIMAL (31, 3) NOT NULL |
| double precision | DOUBLE |
| float | FLOAT NOT NULL |
| image | VARCHAR(4045) FOR BIT DATA |
| int | INTEGER NOT NULL |
| money | DECIMAL (19, 4) NOT NULL |
| nchar(n) | VARCHAR (900) NOT NULL |
| numeric | NUMERIC (31, 3) NOT NULL |
| real | REAL NOT NULL |
| smalldatetime | TIMESTAMP NOT NULL |
| smallint | SMALLINT NOT NULL |
| smallmoney | DECIMAL (10, 4) NOT NULL |
| text | VARCHAR (4045) |
| timestamp | CHAR(8) FOR BIT DATA |
| tinyint | SMALLINT NOT NULL |
| uniqueidentifier | CHAR (38) |
| varbinary(n) | VARCHAR(4045) FOR BIT DATA NOT NULL |
| varchar(n) | VARCHAR (4045) NOT NULL |