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 derived stream's query for pattern matching, which allows detection of patterns of events across one or more sources.
ON Clause: Join Syntax
Specifies the conditions that must be met to perform a join of the data from two sources.
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.
Created August 29, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com