0 - 2 of 2 tags for rowcount

Hi,
ROW_COUNT is returning wrong number.
i have a table having around 100K rows. In a procedure i'm updating all the rows and returning number of rows affected.
I'm using following query to get number of affected rows.
 
GET DIAGNOSTICS v_Variable_Name = ROW_COUNT;
 

Hi, 
So i've been searching all around on how i could increment a column in Teradata. I'm new to this so im not really familiar with all the syntax or tactics that i could use. 
I've read about autogenerated identity column, OLAP and recursive in teradata but i think it does not matches my need. 
So here's my problem.