Event Stream Processor datatypes map to SAP Sybase IQ datatypes.
Any SAP Sybase IQ column datatypes that are marked with an asterisk have data dependent limitations on the mapping. Due to the performance implications of the runtime checks on these mappings, SAP recommends that you do not using them unless modifyinh your database schema is not an option.
| Event Stream Processor Datatypes | SAP Sybase IQ Column Datatypes | Notes |
|---|---|---|
| integer | integer, bigint, money, decimal(p,s), numeric(p,s) tinyint*, smallint* |
If a decimal column is used, p,s >= 10. If the column type in the database is tinyint or smallint, the number is checked during message flow to prevent overflow. |
| long | bigint,
decimal(p,s), numeric(p,s), unsigned int*, unsigned bigint * |
If a decimal column is used, p-s >= 19. If the column type in the database is unsigned int or unsigned bigint, the number is checked during message flow to prevent overflow. |
| float | double,
decimal(p,s), numeric(p,s) |
For the double type, you must specify a precision of at least 16. Float to decimal conversions are not checked and may result in incorrect data being stored if the precision and scale for the decimal is not large enough to store the float. |
| string | varchar, char |
If the destination column is not large enough to store the string value, the value is truncated to fit the column and a warning is written in the ESP Server logs. |
| money | decimal(p,s)*, numeric(p,s)*, money, smallmoney* |
For decimal and numeric
datatypes, s >= 4. If you set the precision to less than 19, the
number is checked at runtime to ensure it fits. If the destination is small money, the value is checked during message flow to prevent overflow. |
| bigdatetime | timestamp, time | If the destination column is time, the date information is discarded from the incoming data ,and only the time portion is stored. |
| timestamp | timestamp | |
| date | timestamp, date |
If the destination column is date, the time information is discarded from the incoming data, and only the data portion is stored. |
| interval | bigint | |
| binary | binary | If the binary object in the Event Stream Processor stream is larger than the destination column in the database, an error is logged in the ESP Server log and the row is discarded. |
| boolean | varchar(5), bit, integer, bigint, unsigned integer, unsigned bigint, smallint, tinyint |
If the column is varchar, the adapter stores "true" for true, and "false" for false. If the column is a bit or other integer type, the adapter stores 1 for true or, 0 for false. |