CCL Queries

The Sybase CEP Continuous Computation Language (CCL) is a language based on the ANSI SQL Standard (1998). It is used to manipulate, analyze and process data within the Sybase CEP Engine.

Like SQL, CCL syntax is structured around commands called statements. One or more CCL statements reside in a query module. When a query module is started, all the CCL statements in it are executed and run continuously until the module is stopped or the Sybase CEP Engine is shut down.

Note:

SQL users should note that CCL is not identical to SQL. Whereas SQL is designed to query data from static tables, CCL is adapted to the needs of processing and analyzing dynamic data. CCL syntax and implementation diverge from the ANSI SQL standard when the requirements of continuous stream and event processing call for such a divergence.

CCL has several types of statements. This chapter introduces you to the simplest forms of the Query Statement. A Query Statement takes data from one or more data sources, processes it and then publishes it to a destination. This is, by far, the most common statement in CCL and can take many complex forms. Other sections of this guide provide more detail on the Query Statement. For complete Query Statement syntax, please see the Sybase CEP CCL Reference.


Created March 8, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com