Three new SQL built-in scalar functions are now available with the SYSIBM schema for processing columns of data defined with a decimal data type:
This function returns the absolute value of the argument. The result of the function has the same data type and length attribute as the argument.
This function returns the product of two arguments as a decimal value. It is especially beneficial when the sum of the precisions of the arguments exceeds 31 (that is, more than 31 decimal places are required for an accurate result).
This function returns expression1 rounded to expression2. The result of the function is to round the value of expression1 to the next higher positive number if expression1 is positive, or to the next lower negative number if expression1 is negative.
See the DB2 Release Notes for more information on these new built-in scalar functions.