Can I use Aggregate Functions In Cursor
Posted: Mon Aug 17, 2009 7:09 pmHai,
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
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