Table 1 lists the data type mapping that is performed when the source data type is Microsoft® SQL Server. In DB2® Everyplace® version 8.1.4 and below, the mapping for Microsoft SQL Server BIT data type is inconsistent between JDBC and upload subscriptions. In JDBC subscriptions, the Microsoft SQL Server data type BIT is mapped to the DB2 Everyplace data type SMALLINT. In upload subscriptions, the Microsoft SQL Server data type BIT is mapped to the DB2 Everyplace data type VARCHAR(1). In DB2 Everyplace version 8.2, the BIT is mapped to SMALLINT in both cases. If you desire the old, inconsistent behavior, run the following script and restart the DB2 Everyplace Sync Server: dsysetproperty "DatatypeMappings Generic Target:*" -7="12 VARCHAR"
Microsoft SQL Server source type | DB2 Version 9.1 mirror data type | DB2 Everyplace device data type | IBM® Cloudscape™ version 10.1 and Derby device data |
---|---|---|---|
BIGINT | BIGINT | VARCHAR | BIGINT |
BINARY | unsupported | unsupported | unsupported |
BIT | SMALLINT | SMALLINT | SMALLINT |
CHAR | CHARACTER | CHARACTER | CHARACTER |
CURSOR | unsupported | unsupported | unsupported |
DATETIME | TIMESTAMP | TIMESTAMP | TIMESTAMP |
DECIMAL | DECIMAL | DECIMAL | DECIMAL |
FLOAT | FLOAT | VARCHAR | FLOAT |
IMAGE | unsupported | unsupported | unsupported |
INT | INTEGER | INTEGER | INTEGER |
MONEY | DECIMAL | DECIMAL | DECIMAL |
NCHAR | GRAPHIC | CHARACTER | CHARACTER |
NTEXT | unsupported | unsupported | unsupported |
NUMERIC | DECIMAL | DECIMAL | DECIMAL |
NVARCHAR | VARGRAPHIC | VARCHAR | VARCHAR |
REAL | REAL | VARCHAR | REAL |
SMALLDATETIME | TIMESTAMP | TIMESTAMP | TIMESTAMP |
SMALLINT | SMALLINT | SMALLINT | SMALLINT |
SMALLMONEY | DECIMAL | DECIMAL | DECIMAL |
TEXT | unsupported | unsupported | unsupported |
TIMESTAMP | unsupported | unsupported | unsupported |
TINYINT | SMALLINT | SMALLINT | SMALLINT |
UNIQUEIDENTIFIER | unsupported | unsupported | unsupported |
VARBINARY or VARBINARY(MAX) | BLOB | BLOB | BLOB |
VARCHAR | VARCHAR | VARCHAR | VARCHAR |