Extended Systems OneBridge 4.1 Guia do Utilizador descarregar pdf (Página 142)

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

1 2 ... 137 138 139 140 141 142 143 144 145 146 147 ... 221 222

Sem comentários

Extended Systems OneBridge 4.1 Guia do Utilizador Página 142