DB2 to Adaptive Server Datatypes

Lists class-level translations from DB2 datatypes to Adaptive Server datatypes.

DB2 Datatype

Adaptive 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