User`s guide

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"