TABLE 2: Manual Conversion of SQL Server Data Types to DB2 UDB for iSeries Data Types
SQL Server Data Type DB2 UDB Data Type
Bigint Numeric(19,0)
Binary(n) Char(n) For Bit Data
Bit Smallint
Char(n) Char(n)
Datetime Date (or Time)
Decimal Numeric(28,14)t
Float Float
Image Varchar(32739) For Bit Data (for V3R2-V4R4)
  BLOB (for V4R5 and higher)
Int Integer
Money Numeric(19,4)
Nchar(n) Char(n)
Ntext Varchar(32739) (for V3R2-V4R4)
  CLOB (for V4R5 and higher)
Numeric Numeric(28,14)
Nvarchar(n) Varchar(n)
Real Real
Smalldatetime Time (or Date)
Smallint Smallint
Smallmoney Numeric (10,4)
Text Varchar(32739) (for V3R2- V4R5)
  CLOB (for V4R5 and higher)
Timestamp Char(8) For Bit Data
Varbinary(n) Varchar(n) For Bit Data
Varchar(n) Varchar (n)