SQL queries



IBM's flagship relational database management system

SQL queries

Postby vissesh » Tue Apr 29, 2014 8:28 pm

How do I get the number of rows got deleted in all the table under the ON DELETE CASCADE rule?

I know SQLERRD(3) gives the total number of rows delted, but I want to know the deleted counts against every table. In other words audit of tables and number of rows deleted.
vissesh
 
Posts: 1
Joined: Tue May 22, 2012 4:55 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post