No of deleted records
Moderators: chulett, rschirm, roy
No of deleted records
How to get the number of records deleted from a table. I am using an oracle_OCI stage and a dummy file. Is there any way to capture the number of records deleted?(In select query we can get the link counts) Any help regarding this will be appreciated.
Rejith R
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
Here one thing you can do, in your design is capture the all rows in a sequential file or Dataset before you delete records in DB.
Another option is ROLLBACK your databse to get your records, based on your commit interval.
Here one thing you can do, in your design is capture the all rows in a sequential file or Dataset before you delete records in DB.
Another option is ROLLBACK your databse to get your records, based on your commit interval.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 210
- Joined: Wed Feb 16, 2005 7:17 am