The Sybase CEP implementation of Structured Query Language (SQL) makes available a subset of SQL-92 commands for querying the contents of CCL public windows.
Though SQL clauses resemble their CCL counterparts, they are not interchangeable. The following table summarizes the differences between CCL and CEP SQL.
| CCL | SQL |
|---|---|
| Used to develop all Sybase CEP applications. | Used to query the current contents of public window, which is created using the Create Window statement and populated in the same way as all other CCL windows. |
| Used inside Sybase CEP Engine query modules. | Used in the Query Public Window dialog box of Sybase CEP Studio, in one of Sybase CEP's SDKs, in the c8_client command-line utility, or in a CCL database subquery. |
| Executes continuously when a project is running, once for every time a row arrives in one of the statement's data sources. | Executes on demand, once each time the query is run. |
This section describes the syntax of the SQL Select statement, and its various clauses. For more detailed descriptions of SQL syntax, refer to SQL-92 documentation.