Analytic Functions

Learn about the addition of new SQL functions.

To support the analysis of large volumes of time-series data stored as rows within a table, Sybase CEP provides a new set of analysis functions and capabilities:

These functions are implemented as aggregate or accumulate functions in CCL; they are not implemented as UDFs. Functions that require numeric data types can accept integer, long, float, timestamp, and interval datatypes.