Rational Developer for System z

Case sensitivity, comments, and special characters in ESQL

This topic briefly describes case sensitivity, comments, and special characters in ESQL.
Important: To fully understand a feature described in this topic, you should read the complete description of the feature in the documentation for WebSphere® Message Broker (see Reference works describing ESQL).

Case sensitivity

ESQL language words are not case-sensitive. This includes keywords, variable names, the names of standard functions, and other entities.

However, a reference to a message or to a message element is case-sensitive (see Field references).

Comments

The subset of ESQL that is supported by the service flow projects tools does not support comments.

Special characters

The following table lists those special characters in ESQL that are operators:
Table 1. Special characters that are operators
Symbol: Name: Usage:
= equals Comparison
  greater than Comparison
< less than Comparison
|| double vertical bar Concatenation
* asterisk Multiply
+ plus Arithmetic add
- minus Arithmetic subtract, date separator, or negation
/ forward slash Arithmetic divide
<> less than greater than Not equals
<= less than or equal Comparison
= greater than or equal Comparison

The following table lists those special characters in ESQL that are not operators:

Table 2. Special characters that are not operators
Symbol: Name: Usage:
; semicolon End of ESQL statement
. period Field reference separator or decimal point
= equals Comparison
[ ] square brackets Array subscript
' single quotation mark Delimit string literal. To specify a single quotation mark inside a string literal, use two single quotation marks.
( ) parentheses Expression delimiter
" quotation mark Identifier delimiter
, comma List separator


Feedback