View previous topic :: View next topic
|
Author |
Message |
Elixir
Active User
Joined: 08 Feb 2009 Posts: 116 Location: CHENNAI/NEW JERSEY - INDIA/USA
|
|
|
|
Hi,
Kindly let me know how to get number of Rows Updated/DElete/Inserted in all the tables used in the program after the program completes successfully. |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Log this information while executing each query... SQLERRD(3) might play role for you |
|
Back to top |
|
|
Elixir
Active User
Joined: 08 Feb 2009 Posts: 116 Location: CHENNAI/NEW JERSEY - INDIA/USA
|
|
|
|
Escapa wrote: |
Log this information while executing each query... SQLERRD(3) might play role for you |
Yes....In case of Update statement, the number of rows updated due to UDPATE statement is logged onto SQLERRD(3).
But is it possible to retrieve the summary of TABLE name and no of rows udpated/deleted/inserted at end? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
But is it possible to retrieve the summary of TABLE name and no of rows udpated/deleted/inserted at end? |
NO, every program should track the relevant <statistic info> |
|
Back to top |
|
|
|