CCL Statements Syntax Summary

Attach Adapter

ATTACH { INPUT | OUTPUT } ADAPTER name TYPE type TO STREAM stream [PROPERTIES { prop = value } [, ...] ] ;

Create Function

CREATE FUNCTION fname ( [ pname type [, ...] ] ) RETURNS type { statement [, ...] } END FUNCTION ;

statement

{ create_variable_statement | assignment_statement | return_statement | break_statement | continue_statement } | { if_statement | case_statement | while_statement }

Create Parameter

CREATE PARAMETER data_type name [= value] ;

Create Schema

CREATE SCHEMA name { (col_name type [, ...]) | INHERITS [FROM] schema_name [, ...] [ (col_name type [, ...]) ] } ;

Create Stream

CREATE [ INPUT | OUTPUT | LOCAL ] STREAM name [schema_clause] [PROPERTIES prop_def [, ...] ] ;

prop_def

{ GUARANTEED DELIVERY = {INHERIT | ENABLE | DISABLE} } | { GUARANTEED DELIVERY MAXIMUM QUEUE SIZE = size } | { GUARANTEED DELIVERY MAXIMUM AGE = age } | { MAXIMUM DELAY = max_delay } | { OUT OF ORDER DELAY = delay } | { SYNCHRONIZATION = { INHERIT | IN ORDER | OUT OF ORDER | USE SERVER TIMESTAMP } } | { FILTERCOLUMNS = " col_name [, ...] " }

Create Variable

CREATE VARIABLE data_type name [= value] ;

Create Window

CREATE [ PUBLIC | MASTER ] WINDOW win_name schema_clause { keep_clause [, keep_clause] } | { MIRROR master_window } [INSERT REMOVED [ROWS] INTO name ] [ properties_clause ]

properties_clause

PROPERTIES [ INDEXCOLUMNS=" col_name [, ...] " ] [ FILTERCOLUMNS=" col_name [, ...] " | [ FILTER=" value [, ...] " ] [ FILTEREXPR=" expression " ] ]

Database

exec_clause select_clause from_clause [matching_clause] [on_clause] [where_clause] [group_by_clause] [having_clause] [order_by_clause] [limit_clause] [output_clause] ;

Delete

on_clause [ when_clause ] DELETE FROM window_name [ where_clause ] ;

Import

IMPORT file ;

Insert Values

insert_clause values_clause output_clause ;

Query

insert_clause select_clause from_clause [matching_clause] [on_clause] [where_clause] [group_by_clause] [having_clause] [order_by_clause] [limit_clause] [output_clause] ;

Remote Procedure

exec_rem_proc_clause select_clause from_clause [matching_clause] [on_clause] [where_clause] [group_by_clause] [having_clause] [order_by_clause] [limit_clause] [output_clause] ;

Set Variable

on_clause [when_clause] set_clause ;

Update Window

on_clause [when_clause] update_clause set_clause [where_clause] [otherwise_insert_clause] ;