Professional JMS
The table below lists the operator and expression syntax in message selectors (based on the SQL-92 SELECT statement syntax):
| Element | Syntax and Specifications |
|---|---|
| Logical | In precedence order: NOT, AND, OR |
| Comparison | =, >, >=, <, <=, <> (not equal) |
| Arithmetic | In precedence order:
|
| Arithmetic range between two expressions | expr1 BETWEEN expr2 AND expr3 expr1 NOT BETWEEN expr4 AND expr5 |
An example of logical operator is usage is:
x NOT = true
An example of arithmetic operator usage is:
y - 64
An example of arithmetic range operator usage is:
z NOT BETWEEN 19 AND 28