How to determine number of rows updated?

[alwaysAnewbie]

I have RTFMed, searched here and teradata forum with no luck.

In Oracle PL/SQL you could find out how many rows the previous update statement affected by using SQL%ROWCOUNT. Is there an equivalent way to do this in Teradata?

 

[Patten]

Sure there is. Equivalent is called in Teradata SQL activity_count.


---do statement eg
select * from yrtable;

---insert nbr of rows affected in a logtable
insert into logtable values activity_count):