The DB2 tutorial you are looking at is: IBM DB2 Daily Maintenance Summary (vii). DB2 function
135.AVG ()
Returns the average of a set of values.
Selectavg (SALARY) Frombsempms;
136.CORR (), Correlation ()
Returns the relationship coefficient of a pair of values.
Selectcorrelation (Salary,bonus) Frombsempms;
137.COUNT ()
Returns the number of rows or values in a group.
SelectCount (*) Frombsempms;
138.COVAR (), covariance ()
Returns the covariance of a pair of values.
Selectcovar (Salary,bonus) Frombsempms;
139.MAX ()
Returns the maximum value in a set of values.
Selectmax (SALARY) Frombsempms;
140.MIN ()
Returns the smallest value in a set of values.
Selectmin (SALARY) Frombsempms;
141.STDDEV ()
Returns the standard deviation of a set of values.
Selectstddev (SALARY) Frombsempms;
142.SUM ()
Returns the and of a set of data.
Selectsum (SALARY) Frombsempms;
143.VAR (), variance ()
Returns the variance of a set of values.
Selectvariance (SALARY) Frombsempms;
144.ABS (), Absval ()
Returns the absolute value of the parameter.
Selectabs ( -3.4) Frombsempms;
145.ACOS ()
Returns the inverse cosine of a parameter.
Selectacos (0.9) Frombsempms;
146.ASCII ()
Returns the ASCII code of the leftmost character of an integer parameter.
Selectascii (' R ') Frombsempms;
147.ASIN ()
Returns the inverse chord function of the argument of the angle expressed in radians.
Selectasin (0.9) Frombsempms;
148.ATAN ()
Returns the inverse tangent of a parameter, the argument of the angle in radians.
Selectatan (0.9) Frombsempms;
149.atan2 ()
Returns the tangent value of the x and y coordinates of the angle expressed in radians.
SELECTATAN2 (0.5,0.9) Frombsempms;
150.BIGINT ()
Returns a 64-bit integer representation of a number or string in an integer constant.
Selectbigint (emp_no) Frombsempms;
151.CEILING () Orceil ()
Returns the smallest integer value that is larger than the argument or equal to the parameter.
Selectceiling (3.56) Frombsempms;
Selectceil (4.67) Frombsempms;
152.CHAR ()
Returns a string representation of a DateTime, String, Integer, decimal, or double-precision floating-point number.
Selectchar (SALARY, ', ') Frombsempms;
153.CHR ()
Returns a character with the ASCII code specified by the parameter.
Selectchar (167) Frombsempms;
<
