SQL Server 2000

Table 217 lists the data type mapping that is performed when the source data type is SQL Server 2000.

SQL Server 2000 source type	DB2 UDB mirror data type	DB2 Everyplace device data type	Cloudscape 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	Unsupported	Unsupported	Unsupported
VARCHAR	VARCHAR	VARCHAR	VARCHAR

Related reference