Extended Systems OneBridge 4.1 Guide de l'utilisateur télécharger pdf (Page 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

Pas de commentaire

Extended Systems OneBridge 4.1 Guide de l'utilisateur Page 142