Statements

A description of various CCL statements.

• ATTACH ADAPTER statement
  Attaches an input or output adapter to an data stream.
• CREATE FUNCTION statement
  CREAT FUNTION enables users to create a user-defined function with the Sybase CEP Function Language.
• CREATE PARAMETER statement
  Creates a parameter within the module or submodule.
• CREATE SCHEMA statement
  Defines a named schema that can be referenced later and reused by one or more queries in the module.
• CREATE STREAM statement
  Creates a data stream attached to the current query module or submodule.
• CREATE VARIABLE statement
  Defines a variable within the scope of the module and, optionally, initializes the variable to a value.
• CREATE WINDOW statement
  Defines a named window that can be referenced later and used by one or more queries.
• Public Windows
  Create Window statements is used to define a public named window, which enables you to perform a snapshot query of a public window with SQL queries from several locations.
• Shared Windows
  Shared windows allow you to perform a snapshot query with live updates, to duplicate contents of one master window in other mirror windows in other projects, and to receive updates to the mirror windows as the master window changes.
• DATABASE statement
  Writes data to an external relational database.
• DELETE statement
  Explicitly deleted specified rows from a named window.
• IMPORT statement
  Imports schemas created with a 'Create Schema Statement' and functions created with a 'Created Function Statement' from an external file.
• INSERT VALUES statement
  Creates one or more rows at specified times, and inserts them into a stream or window.
• QUERY statement
  Subscribes to one or more data sources, processes the incoming rows, and publishes the results into a data stream or named window.
• REMOTE PROCEDURE statement
  Sends Remote Procedure calls (RPCs) to an external destination.
• SET VARIABLE statement
  Changes the value of one or more variables.
• UPDATE WINDOW statement
  Updates existing rows in a named window or, optionally, inserts new rows into the window if no matching rows are found to update.