Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Operators

Operators
A filled square () indicates that the operation can be performed; an empty square () indicates that the operation is invalid.
Relational Operators
Equality Relational Operators (=, ¬=)
 
Ordering Relational Operators (<, >, <=, >=)
 
Concatenation Operator (||)
The concatenation operator, a double vertical bar (||), is valid between any two semantic data types. If one of the operands has syntax W, the result has semantic data type string and syntax W. In all other cases, the result has semantic data type string and syntax V.
Arithmetic Operators
Addition (+)
 
Quantity
Typeless
Date (if COUNT is binary)
Date (if COUNT is binary)
Quantity
Quantity
Quantity
Typeless
Quantity
Typeless
Subtraction (-)
 
Multiplication/Division/Exponentiation (*, /, **)
 
Assignment Operator (=)
 
Resultant Syntax
 
First
Operator
Syntax
Second
Operator
Syntax
Result
Syntax
D=
DMAX
D=
DMAX
D=
DMAX
D=
DMAX
D=MIN
(MAX
(D1,D2),
DMAX))
D=
MIN
(D1+D2,
DMAX)
D=
DMAX
L=MIN
(L1,L2)
L=MIN
(L1,L2)
L=
MIN
(L1,L2)
L=MIN
(L1,L2)
Resultant Syntax Table Key
 
Maximum number of decimal places that the result can hold without overflowing the integer portion
Logical Operators
 
Expression evaluates to true (Y), only if both logical operands are true
Expression evaluates to true (Y), if either (or both) logical operand(s) is true
Expression evaluates to true (Y), only if the logical expression is false
Valid in selection criteria and in the conditions portion of a rule

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved