Default Data Type Mappings

The default mappings HCOSS uses to convert DB2 data types into SQL Server data types.

Restriction: This topic applies to Windows environments only.

DB2 Data Type	Encoding	Data Storage	SQL Server Data Type
BIGINT	All	None	BIGINT
BINARY	All	None	BINARY
BLOB	All	None	VARBINARY(MAX)
CHAR	All	For bit data	BINARY
CHAR	ASCII and EBCDIC	None	CHAR
CHAR	UNICODE	None	NCHAR
CLOB	ASCII	None	NVARCHAR(MAX)
CLOB	ASCII	For bit data	NVARCHAR(MAX)
CLOB	EBCDIC	For bit data	NVARCHAR(MAX)
CLOB	UNICODE	None	NVARCHAR(MAX)
CLOB	UNICODE	For bit data	NVARCHAR(MAX)
CLOB	EBCDIC	None	NVARCHAR(MAX)
DATALINK	All	None	VARCHAR(2083)
DATE	All	None	DATE
DBCLOB	All	None	NVARCHAR(MAX)
DECFLOAT	All	None	FLOAT(53)
DECIMAL	All	None	DECIMAL
DOUBLE	All	None	DOUBLE PRECISION
FLOAT	All	None	FLOAT
GRAPHIC	All	None	NCHAR
INT	All	None	INT
INTEGER	All	None	INTEGER
LONG VARCHAR	All	For bit data	VARCHAR(MAX)
LONG VARCHAR	All	None	VARCHAR(MAX)
LONG VARGRAPHIC	All	None	NVARCHAR(MAX)
LONGVARBIN	All	None	VARBINARY(MAX)
NUMERIC	All	None	NUMERIC
REAL	All	None	REAL
ROWID	All	None	BINARY(40)
SMALLINT	All	None	SMALLINT
TIME	All	None	TIME(0)
TIMESTMP	All	None	DATETIME2(6)
VARBIN	All	None	VARBINARY
VARCHAR	All	For bit data	BINARY
VARCHAR	All	None	VARCHAR
VARGRAPHIC	All	None	NVARCHAR
XML	All	None	XML