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.
| 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 |