CCL Expressions

CCL expressions are combinations of literals, column names, operators, and functions that evaluate to a single value.

price > 80.00 
symbol = 'DELL' 
volume * price 
SQRT(StockTrades.volume) 
(temperature - 32) * 5 / 9 
volume IS NOT NULL 

• Literals
  Sybase CEP expressions can include literals of various datatypes.
• Column Names
  Sybase CEP column names in expressions can be either unqualified, or qualified with a stream name.
• Operators
  Sybase CEP expressions support a variety of numeric, non-numeric, and logical operator types.
• Scalar Functions
  Sybase CEP supports several categories of scalar functions.
• CCL Expressions in the SELECT Clause
  The SELECT clause may contain a list of one or more columns, which are published to the destination stream specified in the INSERT INTO clause. Each of the items in the select list may also be an expression.
• CCL Expressions in the WHERE Clause
  The WHERE clause uses expressions to restrict the data captured by the SELECT clause.