TABLE 1: Automatic DB2 UDB-to-SQL Server Data-Type Conversion
DB2 UDB Data Type SQL Server Data Type
Char Char
Date Smalldatetime
Decimal Decimal
Float Float
Graphic Char
Int Int
Numeric Decimal
Smallint Smallint
Time Smalldatetime (also includes date data)
Timestamp Datetime
Varchar Varchar
Vargraphic Varchar