User`s guide
uBitXOr
128 Sybase IQ ETL 4.1
uBitXOr
Description Calculates the bitwise Exclusive OR over all parameters given and returns the
result.
Syntax number uBitXOr(value, ...)
Parameters
numeric value
A list of numeric arguments.
Examples uBitXOr(10, 3) // returns "9"
uBitNot
Description Calculates the bitwise NOT over all parameters given and returns the result.
Syntax number uBitNot(value, ...);
Parameters numeric value
A list of numeric arguments.
Examples uBitNot(10) // returns "-11"
Boolean functions
uIsAscending
Description Returns 1 if every parameter is equal to or greater than its predecessor.
Syntax number uIsAscending(params, ...)
Parameters
param
A list of expressions or values of any datatype.
Examples To check multiple values for an ascending order:
uIsAscending("A", "B", "C") // returns 1
uIsAscending("A", "A", "C") // returns 1
uIsAscending("A", "C", "B") // returns 0
uIsAscending("1", "2", "3") // returns 1
uIsAscending("3", "2", "2") // returns 0