Clauses
Syntax for the various clauses used in statements .
AGING Clause
Specifies the data aging policy.
AS Clause
Introduces a CCL query to a derived element.
CASE Clause
Conditional processing evaluates set conditions to determine a result.
IN Clause
Used in the LOAD MODULE statement to bind inputs in the module to inputs in the parent scope.
KEEP Clause
Specify either a maximum number of records to retain in a window, or a length of time to retain them.
OUT Clause
Used in the LOAD MODULE statement to expose outputs in the module to the parent scope.
PARAMETERS Clause
Used in the LOAD MODULE statement to provide the bindings for the parameter inside the module at load time.
PRIMARY KEY Clause
Specifies the primary key for a delta stream or window.
SCHEMA Clause
Provides a schema definition for new streams and windows.
STORE Clause
Assigns the store for the window in any window definition.
STORES Clause
Used in the LOAD MODULE statement to bind stores in the module to stores in the parent scope.
Created April 23, 2012. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com