Event Stream Processor includes several stream and window examples that demonstrate a range of functionality, including how to use delta streams, make joins and unions, and split streams.
Note: The example syntax occasionally wraps due to space constraints. Wrapped lines should be entered on a single line.
Outer Join
Create left, right, and full joins between input windows.
Union Streams
Create a simple union between two windows.
Jumping Windows
Jumping Windows retain data for a specified interval of time or for a specified number of rows and delete all retained rows when the specified interval of time expires, or the specified number of rows is exceeded.
Splitter
Use the splitter feature to route data from one stream to multiple streams.
Created August 28, 2012. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com