Show TOC

Datatype Mapping: IBM DB2 DatabaseLocate this document in the navigation structure

Mapping between Event Stream Processor datatypes and IBM DB2 9.7 datatypes.

Event Stream Processor Datatype IBM DB2 Datatype
integer int
long bigint
float float
seconddate timestamp
string varchar(n)
money decimal(19,5)
msdate timestamp
boolean smallint

or

bit (Does not support null values)
money1 decimal(19,1)
money2 decimal(19,2)
money3 decimal(19,3)
money4 decimal(19,4)
money5 decimal(19,5)
money6 decimal(19,6)
money7 decimal(19,7)
money8 decimal(19,8)
money9 decimal(19,9)
money10 decimal(19,10)
money11 decimal(19,11)
money12 decimal(19,12)
money13 decimal(19,13)
money14 decimal(19,14)
money15 decimal(19,15)
interval bigint
bigdatetime timestamp
binary blob