CCL Clauses

Syntax for the various clauses used in statements .

• AGING Clause
  Specifies the data aging policy.
• AS Clause
  Introduces a CCL query to a derived element.
• AUTOGENERATE Clause
  Specify one or more columns that will contain an automatically generated sequence number in records sent to an input stream or input window.
• CASE Clause
  Conditional processing evaluates set conditions to determine a result.
• FROM Clause
  Identifies the stream(s) or window(s) or both that will provide the input to the query.
• GROUP BY Clause
  Specifies the expressions on which to perform an aggregation operation.
• GROUP FILTER Clause
  Filters data in a group before the aggregation operation is performed.
• GROUP ORDER BY Clause
  Orders the data in a group before applying the GROUP FILTER clause and aggregating the data.
• HAVING Clause
  Filters rows that have been grouped by a grouping clause.
• IN Clause
  Used in the LOAD MODULE statement to bind inputs in the module to inputs in the parent scope.
• KEEP Clause
  Specify either a maximum number of records to retain in a window, or a length of time to retain them.
• MATCHING Clause
  This is used within a query for pattern matching, which allows detection of patterns of events across one or more sources.
• ON Clause: Join Syntax
  Specifies join conditions for syntax using JOIN terminology.
• OUT Clause
  Used in the LOAD MODULE statement to expose outputs in the module to the parent scope.
• PARAMETERS Clause
  Used in the LOAD MODULE statement to provide the bindings for the parameter inside the module at load time.
• PRIMARY KEY Clause
  Specifies the primary key for a delta stream or window.
• SCHEMA Clause
  Provides a schema definition for new streams and windows.
• SELECT Clause
  Specifies a projection list for a query.
• STORE Clause
  Assigns the store for the window in any window definition.
• STORES Clause
  Used in the LOAD MODULE statement to bind stores in the module to stores in the parent scope.
• UNION Operator
  Combines the result of two or more SELECT clauses into a stream or window.
• WHERE Clause
  Specifies a selection condition, join condition, update condition, or delete condition to filter rows of data.