SAP Sybase Event Stream Processor 5.1 SP04 includes two new datatypes, DECIMAL and TIME, along with two new aliases, BIGINT and DOUBLE.
The new datatypes are supported in schema definitions in CCL and SPLASH, and in declarations inside DECLARE blocks. They are also supported in all of the adapters supplied by SAP and in the PowerDesigner extensions for ESP.
The DECIMAL datatype is used to represent numbers that include decimal points. A decimal specification accepts two parameters: precision (maximum number of digits allowed) and scale (maximum number of digits that can be to the right of the decimal point). The scale parameter is optional: by default, it is set to zero.
The TIME datatype is used to represent the time of day. It stores the number of seconds from midnight.
BIGINT is an alias for LONG, and DOUBLE is an alias for FLOAT.