logo  
Google
 

DB2 SQL-Error: -111

SQLState: 42901

Short Description: AN AGGREGATE FUNCTION DOES NOT INCLUDE A COLUMN NAME

The specification of an aggregate function (for example: AVG, MAX, MIN, or SUM) was invalid because such functions must include a column name in the operand. In a trigger definition, a transition variable specification does not qualify as a column name for this purpose. This message is still issued with Version 8 prior to New Function Mode. System action: The statement cannot be executed. Programmer response: A column name must be specified as an operand to the function. Refer to Chapter 3 of DB2 SQL Reference for information about the proper usage of aggregate functions.

 <-  BACK TO INDEX