Microsoft SQL Server data type mappings

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"

Table 1. Data type mapping from Microsoft SQL Server
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