Message : CPD439B
DISTINCT or ALL not valid for use.
Message Long Text :
Cause . . . . . : The DISTINCT or ALL keyword was specified in conjunction with the parameter for function &1. These keywords are only allowed for use with a column function. However, the function is a scalar function. Recovery . . . : Refer to the DB2 for IBM i SQL Reference topic collection in the Database category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/ for more information on built-in and user-defined functions. Remove the keyword. Try the request again.