Extended Systems OneBridge 4.1 Betriebsanweisung PDF herunterladen (Seite 172)

uFirstDifferent

158 Sybase IQ ETL 4.1

string values

List of values.

Examples Example 1 IF construct:

uChoice(0, "A", "B") // returns "A"

uChoice(1, “A”, “B”) // returns “B”

Example 2 CASE constructs:

uChoice(2, "n.a.", "Jan", "Feb", "Mar") //returns "Feb"

Example 3 Simulate a lookup function where you want to replace a color ID

with a corresponding color name:

uChoice(IN.Color, “n.a.”, “Red”, “Blue”, “Green”)

uFirstDifferent

Description Returns the first parameter value that is different from the first parameter.

Syntax string uFirstDifferent(params, ... )

Parameters

params

A list of expressions or values of any data type.

Examples To find the first different attribute in a list:

uFirstDifferent("2004-05-01", "2004-05-01", "2005-01-

04", "2005-11-24",) //returns "2005-01-04"

uFirstNotNull

Description Returns the first non-null value in the list.

Syntax string uFirstNotNull(params, ...)

Parameters

params

A list of expressions or values of any data type.

Examples To merge four distinct attribute values:

uFirstNotNull(null, null , "A", "B") // returns "A"

1 2 ... 167 168 169 170 171 172 173 174 175 176 177 ... 221 222

Keine Kommentare

Extended Systems OneBridge 4.1 Betriebsanweisung Seite 172