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 |
| date | timestamp |
| string | varchar(n) |
| money | decimal(19,5) |
| timestamp | 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 |