DB2 to Microsoft SQL Server Datatypes

Lists class-level translations from DB2 datatypes to Microsoft SQL Server datatypes.

DB2 Datatype

Microsoft SQL Server Datatype

CHAR FOR BIT DATA

binary

DATE

datetime

DECFLOAT UDB (UNIX and Windows only)

float

DOUBLE (UNIX and Windows only)

float

REAL (UNIX and Windows only)

real

TIME

datetime

TIMESTAMP

datetime

VARCHAR FOR BIT DATA

varbinary