IBM Mainframe Forum

Hai,

I want to use a Aggregate Function SUM in Cursor in Application Program like below

exec sql
Declare cur1 cursor for
select pol-type,sum(pol-amt) from policy
group by pol-type order by pol-type
end-exec
........
.......


plz some one help me

Hello,

It is ok to use an aggregate with a cursor, but the cursor will be read-only.