The syntax as given in Oracle built-in function, it is to convert lower case letters into upper case letters. The explanation given here is with examples. So that you use in your SQL program directly.
The best example for TRUNC function that truncates to nearest date format in SQL
There are 4 functions present in DB2. These are scalar functions, aggregate functions, Table functions and Row functions. Each function has its own purpose and use.
SUM aggregate function explained how to use on multiple table columns and given sample SQL query.
The example to created function in DB2.
Top differences of Aggregate functions and Scalar functions