IBM DB2/MVS subscriptions to Microsoft®SQL Server™ publications are supported through the ODBC driver that is included with Microsoft SNA Server version 4.0. For more information on the ODBC driver, see Driver Support for Heterogeneous Data Sources. SQL Server Setup installs the driver automatically.
The following table maps SQL Server data types to IBM DB2/MVS data types. When you replicate to ODBC Subscribers, the distribution task maps SQL Server data types to the closest data type on the target database.
| SQL Server data type | DB2/MVS data type |
|---|---|
| binary(n) | VARCHAR(900) FOR BIT DATA NOT NULL |
| bit | SMALLINT |
| char(n) | VARCHAR (900) NOT NULL |
| datetime | TIMESTAMP NOT NULL |
| decimal | DECIMAL (28, 14) NOT NULL |
| float | FLOAT NOT NULL |
| image | VARCHAR(32704) FOR BIT DATA |
| int | INTEGER NOT NULL |
| money | DECIMAL (19, 4) NOT NULL |
| nchar(n) | VARCHAR (900) NOT NULL |
| ntext | VARCHAR (32704) |
| numeric | NUMERIC (28, 14) NOT NULL |
| real | REAL NOT NULL |
| smalldatetime | TIMESTAMP NOT NULL |
| smallint | SMALLINT NOT NULL |
| smallmoney | DECIMAL (10, 4) NOT NULL |
| text | VARCHAR (32704) |
| timestamp | CHAR(8) FOR BIT DATA) |
| tinyint | SMALLINT NOT NULL |
| uniqueidentifier | CHAR (36) |
| varbinary(n) | VARCHAR(900) FOR BIT DATA NOT NULL |
| varchar(n) | VARCHAR (900) NOT NULL |