Adaptive Server to DB2 Datatypes

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

Adaptive Server Datatype

DB2 Datatype

bigdatetime

TIMESTAMP

bigint

BIGINT

bigtime

TIMESTAMP

binary

CHAR FOR BIT DATA

bit

TINYINT

date

DATE (UNIX and Windows only)

datetime

TIMESTAMP

decimal

DECIMAL

int

NUMERIC

money

NUMERIC

numeric

NUMERIC

real

REAL (UNIX and Windows only)

smalldatetime

TIMESTAMP

smallint

NUMERIC

smallmoney

NUMERIC

time

TIME (UNIX and Windows only)

tinyint

NUMERIC

unsigned bigint

DECIMAL (20,0)

unsigned int

BIGINT

unsigned smallint

INTEGER

unsigned tinyint

SMALLINT

unitext

DBCLOB

varbinary

VARCHAR FOR BIT DATA