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
Here are the top reasons why you cannot use count all in production boxes.
The SQL AVG function computes the average of the values for the column( or expression)…
DB2 SQL TRIM,UNPACK and DATE functions to write SQL query better way.
NULLIF returns a null value if the two arguments of the function are equal. If…
CAST can be used to change the data type of an expression to a different data…
The SQL functions are highly beneficial for SQL developers and ETL developers. Read best examples on TRIM, LTRIM and RTRIM.