DB2 Everyplace 9.1.1 for Lotus Expeditor 6.1.1

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
Related reference
Data type mappings between DB2 Everyplace and data sources
DB2 family data type mappings
Informix data type mappings
Oracle data type mappings


Library | Support | Terms of use |

Last updated: July, 2007
(C) Copyright IBM Corporation 2004, 2007. All Rights Reserved.
This information center is built on Eclipse. (http://www.eclipse.org)