Using the Sybase CEP RTD Plugin and Function

The Microsoft Excel RTD() function supports =RTD(ProgID,Server,String1,[String2],...) syntax. Describes the parameters of this function, including the ProgID and Server values, and String..StringN parameters.

=RTD(ProgID,Server,String1,[String2],...)

The parameters of this function are as follows:

• The ProgID value is the COM program ID of the RTD server plugin. In this case, the function call refers to the Sybase CEP RTD plugin program which has the ID C8.RTD.

• The Server value is the URL of the location of the server where the RTD plugin is installed. The Sybase CEP RTD plugin is installed on the local machine, requiring this value to be left blank. Therefore, all syntax references and examples for the Sybase CEP RTD plugin leave the second value empty (",,"). This is the correct syntax.

• The String1..StringN parameters are specific to the plugin being used. The Sybase CEP RTD plugin for Excel uses these parameters to form the query.

Using the standard Microsoft Excel RTD() function syntax as a reference, the Sybase CEP RTD function takes the following syntax:

=RTD("C8.RTD", [, "STREAMURI", stream-uri] 
  [, "FIELD", field-name] [, "INDEX", index] 
  [, "FILTER", field-name, field-value])

The parameters to the function are described below:

"C8.RTD": The ProgID of the RTD server. It tells Excel to use the Sybase CEP Adapter to interpret the rest of the arguments.
"STREAMURI": Specifies the stream from which the RTD server subscribes and extracts the data. It can be a full stream URI or a stream alias configured in the registry. If you specify the full URI, you must declare it as follows (please refer to the Sybase CEP Engine documentation for more details):

ccl://[user:password@]host[:port]/Stream/
   workspace-name/project-name/stream-name

"FIELD": Specifies which field value to take from the tuple.
"INDEX": Specifies how far back to go into the tuple history. A value of "1" specifies the most recent tuple. A value of "2" specifies the next most recent, and so on.
"FILTER": Specifies a filter to refine the tuples that are returned. For example, the arguments ("FILTER", "Symbol", "DELL") only matches tuples where the Symbol field equals "DELL".