Sybase CEP column names in expressions can be either unqualified, or qualified with a stream name.
An example of an unqualified stream name is symbol , where the qualified stream name would be StockTrades.symbol . When unqualified column names are used, the usage must be unambiguous within the query.
If two or more streams have the same column name, then the use of that column name in an expression will generally require a qualified name (it is not legal for the same schema to have two columns with the same name). Column names are case-insensitive, so symbol and Symbol are treated as the same column name in Sybase CEP.
For a complete explanation of how column names are used with CCL, please see the Sybase CEP CCL Reference.