User`s guide

uAvg
126 Sybase IQ ETL 4.1
Aggregation functions
uAvg
Description Calculates and returns the average value of all input values.
Syntax real uAvg(value, ...);
Parameters
numeric value
A list of numeric arguments to calculate the average value over.
Examples To calculate the average value:
uAvg(1,2,3,4,5) // returns 3
uMax
Description Returns the highest value from a set of values. This function compares the
values depending on their datatype.
Syntax uMax(value, ...)
Parameters numeric value
A list of numeric arguments.
Examples To find the highest value from a set of values:
uMax(1, 6, 4, -6) // returns 6
uMax("b", "A", "a") // returns "b"
uMax("2004-05_02", "2006-12-12", "1999-05-30") //
returns "2006-12-12"
uMin
Description Returns the lowest value from a set of values.
Syntax uMin(value, ...)