var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to get rowcount of last select query in db2 stored procedure?
I want to get the number of rows returned by the last select query, in the db2 stored procedure?
Bottom line, i want an alternative to sql%rowcount commnd of ORACLE.
Can any body suggest something
This will work.
1.Declare a variable say COUNTER as Integer.
DECLARE COUNTER INTEGER;
2.SELECT COUNT(*) INTO COUNTER FROM db2admin.TABLENAME T WHERE T.COLUMNNAME =(any required condition) ;
Prashant G Dahalkar