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.
SQL queries
Previous topic • Next topic • 1 post
• Page 1 of 1
SQL queries
by vissesh » Tue Apr 29, 2014 8:28 pm
- vissesh
- Posts: 1
- Joined: Tue May 22, 2012 4:55 pm
- Has thanked: 0 time
- Been thanked: 0 time
Previous topic • Next topic • 1 post
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Queries in DB2
by deepu.surya » Wed Jan 28, 2009 12:45 pm - 1 Replies
- 2100 Views
- Last post by dick scherrer
Wed Jan 28, 2009 1:52 pm
- Queries in DB2
-
- Difference between queries
by Shakthivel V » Sun Nov 07, 2010 12:04 pm - 2 Replies
- 2010 Views
- Last post by dick scherrer
Sun Nov 07, 2010 10:07 pm
- Difference between queries
-
- Performance Tuning SQL queries
1, 2by SANDHYA BUDHI » Tue Jul 22, 2008 11:24 am - 12 Replies
- 8478 Views
- Last post by henri2398
Wed Dec 16, 2015 11:41 am
- Performance Tuning SQL queries
-
- collection of sql queries needed for db2????
by aashishpathak » Mon Jun 21, 2010 3:38 pm - 3 Replies
- 2746 Views
- Last post by maxcc
Mon Jul 19, 2010 7:36 pm
- collection of sql queries needed for db2????