Question

Locked

There is a delete sql on a DB2 table. Because of delete cascade, rows are g

By sunil.sas ·
There is a delete sql on a DB2 table. Because of delete cascade, rows are getting deleted from two tables in a single SQL. How can I get the number of rows deleted from child table? Is there any way out?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Only way I can think of

by Tony Hopkinson In reply to There is a delete sql on ...

is to do a select count query on the dependent table.
If I had to do it, and I'd need a good reason to even bother, would probably wrap the entire think up in a stored proc.

The whole point of cascade is to be transparent, wanting to know this almost defeats having it in the first place.

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums