CCL Lexical Conventions

CCL Statement enable users to use tabs, carriage returns, and spaces within the definition of the statement.

CCL statements can include one or more tabs, carriage returns, spaces, or comments anywhere a space occurs within the definition of the statement. For example, the following two statements are evaluated the same way:

INSERT INTO AverageStockPrice
SELECT stocks.price, AVG(stocks.price)
FROM stocks
GROUP BY stocks.Symbol

INSERT INTO AverageStockPrice
SELECT stocks.price,
AVG(stocks.price)
FROM stocks
GROUP BY stocks.Symbol

Case is insignificant in CCL keywords, also called reserved words, and identifiers (stream names, column names, parameter names, and so on). However, CCL text literals are case-sensitive.

CCL names include CCL query identifiers, as well as project and module names, adapter names, aliases and the names of windows. Names and identifiers must start with a letter. Subsequent characters can be letters, digits, or underscores (_). The prefixes C8_ and XML are reserved for Sybase® CEP Engine names.

None of the CCL reserved words can be used as an identifier. All reserved words are listed in Reserved Words.

CCL programs support the following UTF-8 characters:

If you need to use other UTF-8 characters, you can use the corresponding integer and convert it to the desired character with the CHR function.