can we use GROUP BY clause in declare cursor?

babu_hi · New User Joined: 11 Apr 2006 Posts: 93

dbzTHEdinosauer · Posted: Wed Apr 16, 2008 8:01 pm

if it is a fetch only cursor

shrivatsa · Posted: Wed Apr 16, 2008 8:10 pm

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.

l.nethaji · Posted: Thu Apr 17, 2008 3:52 pm

its right to delcare cursor using group by clause

declare cursor cur1

select c1,c2 from t1 group by c1,c2

then in the fetch u must give

fetch cur1

into :wc1

into:wc2

wc1 ,wc2 are working storage variables