Subscribing to the Sybase CEP Server

To view streaming data from the Server, define a cache and use it as the data source to the table.

You may specify certain properties in the cache. These properties are necessary for viewing updates and deletes to the data:

valueTable – Table containing the inserts and updates for the Stream you wish to view. To set this property, right-click on the valueTable property of the table object, and select Attach To Data > C8. A window appears where you may choose a predefined connection. Next, choose the stream and columns in the Streams you wish to view. You may choose the columns you wish to include in the Cache as long as the index columns specified have been selected.
indexColumNames – Use this to specifiy the key columns for the Streams. You may specify this by separating the column names by a semicolon. For example, KeyCol1;KeyCol2. Note that the column names are case sensitive.
deleteTable – Table that contains the delete records. You may follow the steps above to set the valueTable property, except for choosing the Stream name. Since the Server does not have a specific delete table, a virtual table name is used. The virtual name is derived by prefixing the Stream name chosen for the valueTable property with a "!". For example, if the stream name chosen is 'Positions', then the deleteTable will be '!Positions'. Note that there is no such stream in the Server, so type in the StreamName rather than choosing it from the drop down list.
maxNumberOfRows – This value is 0 by default and it means that there is no history of records maintained for an index. Therefore, only the most recently arrived row for an index is displayed. This is sufficient for objects that display only the most recent data such as Tables, and Pie Charts, but for having a history may be necessary for objects that display trends.
Setting this value to anything greater than 0 enables the history mechanism. For every key value, there will be N rows of history maintained, where N is the number of rows specified for this option.

The cache needs to be created in a separate rtv file and this file be imported into the main rtv file by selecting Tools > Options > Caches selection. Also, note that if any changes are made to the cache after it has been imported into the main display file, the cache needs to be refreshed again by selecting Tools > Options > Refresh Selection.

To use the cache in a table object:

Right click on the valueTable property of the table object.
Select Attach To Data > Cache.
A new window displays. Choose the cache name.
For the Stream, choose 'Current'.
Next, choose the columns that need to be displayed.

Note: There is an additional column available in the cache, called the time_stamp column. Displaying this column is optional.