Input Stream

Schema to create an input stream for Reuters data.

The schema for an input stream can include the String columns Symbol, which contains the symbol from the Reuters feed, and Service, which contains the service name from the feed. All additional columns should be valid Reuters Field IDs (fids). These additional columns contain the data from the corresponding field in the Reuters data feed. If the Reuters feed does not contain data for a specified fid, the adapter writes Null to that column and prints a warning message.

A Sybase CEP CCL column name cannot begin with a number. If your Reuters data includes Field IDs that begin with a number, preface the corresponding column name with RFA_. For example, if your data includes a fid of 52WK_HIGH, you should name the corresponding column in the schema RFA_52WK_HIGH.

The Reuters datatypes do not map exactly to Sybase CEP datatypes. Use this table to determine the appropriate datatypes for the additional columns in your input stream schema:
Reuters datatypes Sybase CEP datatype
Int32, UInt32 Integer Integer
Int64, UInt64 Long
Float, Double, Real32, Real64 Float
Date, Time, DateTime Timestamp
Enumeration Integer
StringASCII, StringUTF8, StringRMTES, Enumeration String
Quality of Service, RespStatus, Opaque, XML, Buffer, AnsiPage Not processed