DB2 SQL-Error: -441
SQLState: 42601
Short Description: INVALID USE OF DISTINCT OR ALL WITH SCALAR FUNCTION
The keyword Â’DISTINCTÂ’ or Â’ALLÂ’ was detected within parentheses in a reference to function function-name and the function has been resolved as a scalar function. Use of the keyword Â’DISTINCTÂ’ or Â’ALLÂ’ with a scalar function is invalid. System action: The statement cannot be executed. Programmer response: If a scalar function is being used, then remove the keyword Â’DISTINCTÂ’ or Â’ALLÂ’. If an aggregate function is being used, then there is a problem with function resolution. Check your SQL path to see if the desired function is in one of the schemas, and also check the SYSIBM.SYSROUTINES catalog for the spelling of the function name and the number and types of parameters.