Datatype Mapping for the SAP IQ Output Adapter
Event Stream Processor datatypes map to SAP IQ datatypes.
Any SAP 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 use them unless modifying your database schema is not an option.
| Event Stream Processor Datatypes | SAP IQ Column Datatypes | Notes |
|---|---|---|
| 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. |
| 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. |
| seconddate | timestamp, date |
If the destination column is date, the time information is discarded from the incoming data, and only the data portion is stored. |
| decimal | decimal, numeric |
ESP performs runtime checks to ensure the whole-number portion of your decimal fits into the database column. However, ESP does not ensuer the fractional portion fits into the database column. |
| 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. |
| 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. |
| interval | bigint | |
| 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. |
| 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. |
| 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. |
| time | time, bigdatetime | When the ESP time value is mapped to the SAP IQ bigdatetime value, the date portion is set to January1, 1970 (the UNIX epoch). |
| msdate | timestamp |