Event Stream Processor includes several data selection examples that demonstrate a range of functionality, including how to apply GROUP BY, AGING, and WHERE clauses to data.
Note: The example syntax occasionally wraps due to space constraints. Wrapped lines should be entered on a single line.
AGING Column
Use the AGING clause to set an age column for an output window.
MATCHING clause
Place a MATCHING clause on an output stream.
Matching a Sequence of Events
Place MATCHING and WHERE clauses on output streams to produce a set of sequenced data.
Matching Non-Events
Place a MATCHING clause with a not (!) condition on an output stream.
Row Time
Use the bigdatetime system column to retrieve row-insertion times.
AUTOGENERATE Clause
Use the AUTOGENERATE clause in an input window to automatically generate values that function as primary keys for input data that does not have a natural primary key.
Created August 28, 2012. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com