The Sybase CEP remote database query feature enables users to query a remote database or public window with CCL statements.
The term "remote database query" refers either to a database subquery that selects data from a remote database server, or a database statement.
The remote database server refers to a database server that runs outside the Sybase CEP Server process, either on the same computer as Sybase CEP Server, or on a different computer. Sybase CEP's remote database query feature enables CCL statements to execute a query on a remote database server. The query can be a SELECT statement that returns data, or can be some other type of query/statement, such as an INSERT, UPDATE, or DELETE.
A query module can also use a remote database query to query a public window in another module. For more detail, see Public Windows.
The CCL statement can use parameters to pass information from CCL statements to SQL statements. For example, if the current row in the query on Sybase CEP Server has "DEPT = 'Accounting'" , then the SQL query that you pass to the remote database server may have a WHERE clause similar to "... WHERE DEPT = ?DeptName" . The "?DeptName" tells Sybase CEP Server that the SQL query text should be updated to look like "... WHERE DEPT = 'Accounting'" . For more details see Sybase CEP CCL Reference Guide .