Clauses

CACHE clause
Clears the cache when a row arrives in a stream, in either database subquery or remote subquery.
EXECUTE REMOTE PROCEDURE clause
Specifies the name of a predefined service that should be invoked by the Remote Procedure Statement and the values of the service parameters.
EXECUTE STATEMENT DATABASE clause
Specifies the name of an external relational database connection and the SQL or q statements that should be executed against the database.
FROM clause
Used for single-source queries, used for joins that use the JOIN syntax, and it is used for database subqueries and to remote subqueries.
FROM clause: Comma-separated syntax
Specifies one or more data sources in a Query statment, Database statement, or Remote Statement.
FROM clause: Database and remote subquery syntax
Retrieves data from a relational database, public window, or another remote source, directly into a CCL query.
DATABASE subquery
Retrieves data from relational database tables or from CCL public windows into a Query statement, database statement, or remote procedure statement and can also specify cache settings.
REMOTE subquery
Sends Remote Function Calls (RFCs) to an external service, and retrieves the resulting data into a Query statement, Database statement, or Remote Procedure statement.
FROM clause: Join syntax
Specifies two data sources in a Query Statement, Database statement, or Remote Procedure statement for inner and outer joins created in the JOIN keyword syntax.
CCL Subqueries in the FROM Clause
Creates a CCL subquery inside the FROM clause of a Query statement, Database statement, or remote preocedure statement.
XMLTABLE expressions
Produces an XML table output from one of the data sources in a Query statement, Database statement, or Remote Procedure statement.
GROUP BY clause
Affects the behaviour of aggergate functions and the OUTPUT clause in the Query statement, database statement, or Remote procedure statement.
HAVING clause
Specifies an optional post-aggregation selction condition in a Query statement, Database statement, or remote procedure statement.
INSERT clause
Indentifies destinations for the results of a Query statement or Insert Values statement.
INSERT INTO clause
Indentifies a single destination for the results of Query statement or insert values statement.
INSERT WHEN clause
Identifies a single destination for the results of a continuous query created by a Query statement.
KEEP clause
Specifies a window policy in a Create window statement or in the From clause of a Query Statement, Database statement, or Remote Procedure statement.
MATCHING clause
Detects a pattern of events with specified temporal relationships.
ON clause
Specifies join conditions for joins preformed using the JOIN keyword, creates a pattern join condition, or used to identify the trigger which causes rows to be deleted, updated, or inserted into a named window, or which causes variables to change state.
ON clause: Trigger syntax
Specifies the stream or named window in which the arrival of a row triggers the deletion of rows from a named window or the resetting of a variable state.
ON clause: Join syntax
Specifies a join condition for data sources joined with a JOIN keyword.
ON clause: Pattern matching syntax
Optional clause that specifies a pattern join condition. This form of ON syntax is used in conjunction with a MATCHING clause in a Query statement, database statement, or remote procedure statement.
ORDER BY clause
Orders multiple rows produced simultaneously by a join operation in a Query Statement, Database statement, or Remote Procedure statement.
OTHERWISE INSERT clause
Defines a list of values and column associations, which generates a new row and publishes it to the destination named window specified in an Update Window statemen if a trigger occurs but no current rows in the window match the statement's update condition.
OUTPUT clause
Sychronizes, limits, or delays output from a Query statement, database statement, or Remote Procedure statement, or schedules the generation of rows from an Insert Values statement.
SCHEMA clause
Provides a schema definition for a named window inside a Create Windowstatement, or for a database subquery or remote subquery inside a Query statement, Database statement, or Remote Procedure statement.
SELECT clause
Specifies a select list for a query in a Query Statement or Database statement or passes values to the parameters of an external service in a Remote procedure statement.
SET clause
Sets variables and updates rows in a window.
SET clause: Set variable statement syntax
Sets the values of one or more variables in a Set Variable statement.
SET clause: Window syntax
Indicates which columns of a named window should be updated by the Update Window statement and specifies values for those columns.
UPDATE clause
Specifies the named window in an Update Window statement on which the update or insert should be performed.
VALUES clause
Specifies a list of values in an Insert Values statement to be generated at the specified time and inserted into the statement's destination.
WHEN clause
Defines a condition that narrows the cases in which the trigger occurs in a Delete statement, Set Variable statement, or Update Window statement.
WHERE clause
Specifies a selection condition for filtering input from data sources in a Query Statement, Database statement, or Remote Procedure statement, provides join conditions in the FROM Clause: Comma-separated syntax, update conditions in an Update Window statement, and delete conditions in a Delete statement.