Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » QAnywhere » QAnywhere Transmission and Delete Rules » Rule syntax

Schedule syntax Next Page

Condition syntax


QAnywhere conditions use a SQL-like syntax. Conditions are evaluated against messages in the message store. A condition evaluates to true, false, or unknown. If a condition is empty, all messages are judged to satisfy the condition. Conditions can be used in transmission rules, delete rules, and the QAnywhere programming APIs.

Keywords and string comparisons are case insensitive.

Syntax

condition :
expression IS [ NOT ] NULL
| expression compare expression
| expression [ NOT ] BETWEEN expression AND expression
| expression [ NOT ] LIKE string [ ESCAPE character ]
| expression [ NOT ] IN ( string, ... )
| NOT condition
| condition AND condition
| condition OR condition
| ( condition )

compare: = |> | < | >= | <= | <>

expression:
constant
| rule-variable
| -expression
| expression operator expression
| ( expression )
| rule-function ( expression, ... )

integer: An integer in the range -2**63 to 2**63-1

number: A n umber in scientific notation in the range 2.2250738585072e-308 to 1.79769313486231e+308

string: A sequence of characters enclosed in single quotes. A single quote in a string is represented by two consecutive single quotes.

constant: integer | number | string | TRUE | FALSE

operator: + | - | * | /

rule-variable:

See Rule variables.

rule-function:

See Rule functions.

Parameters