The CCL statement can be either a DATABASE statement or may be a subquery that makes a remote query call.
Below is a pseudocode example:
-- Create the table. EXECUTE STATEMENT DATABASE "LocalOracleDB4" [[CREATE TABLE Data1 ( Integer_col INTEGER, Long_col NUMBER(21) )]] SELECT SetupStream.command AS command FROM SetupStream WHERE command = "CREATE TABLE" ;
If there is no filter (such as a WHERE clause), the CREATE TABLE statement is called each time a new row arrives in any of the streams involved in the CCL statement.
For more information about the syntax of these CCL statements and clauses, see the Sybase CEP CCL Reference Guide .