Joined: 17 Mar 2006 Posts: 171 Location: Bangalore
From DB2 Manual I found below:-
A cursor will be automatically classified as
read-only if its SELECT statement is a join of multiple tables or includes such clauses as ORDER BY or GROUP BY.
The above statement says that we can use GROUP BY Clause. But remeber it will be read-only. You cannot do update.