IBM DB2/AS400 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/AS400 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/AS400 data type |
|---|---|
| binary(n) | CHAR(8000) FOR BIT DATA |
| bit | SMALLINT |
| char(n) | CHAR (8000) |
| datetime | TIMESTAMP |
| decimal | DECIMAL |
| double precision | DOUBLE |
| float | FLOAT |
| image | VARCHAR(32739) FOR BIT DATA |
| int | INTEGER NOT NULL |
| money | DECIMAL (19, 4) |
| numeric | NUMERIC |
| real | REAL |
| smalldatetime | TIMESTAMP NOT NULL |
| smallint | SMALLINT |
| smallmoney | DECIMAL (10, 4) NOT NULL, |
| text | VARCHAR (32739) |
| timestamp | CHAR(8) FOR BIT DATA) |
| tinyint | SMALLINT NOT NULL |
| uniqueidentifier | CHAR (36) |
| varbinary(n) | VARCHAR(8000) FOR BIT DATA NOT NULL |
| varchar(n) | VARCHAR (8000) NOT NULL |