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