View previous topic :: View next topic |
Author |
Message |
nadh Intermediate
Joined: 08 Oct 2004 Posts: 192 Topics: 89
|
Posted: Mon Jul 18, 2005 9:21 am Post subject: how to find the no. of records updated or inserted in table |
|
|
Hi,
How to find the number of records updated or inserted into a table?
I know one method, using sqlerrd(3). is there any other way? Pls. let me know.
Thanks
Nadh |
|
Back to top |
|
|
schintala Beginner
Joined: 18 May 2005 Posts: 108 Topics: 31 Location: USA
|
Posted: Mon Jul 18, 2005 9:58 am Post subject: |
|
|
You can do it in program. You may have to write a logic using some sort of incremental counter for each record inserted/updated. You can refer the same count for commit later in the program. The other you said. I can think of this much. |
|
Back to top |
|
|
nadh Intermediate
Joined: 08 Oct 2004 Posts: 192 Topics: 89
|
Posted: Mon Jul 18, 2005 10:10 am Post subject: |
|
|
HI
I want to know whether we can find from SYSIBM tables.
nadh |
|
Back to top |
|
|
schintala Beginner
Joined: 18 May 2005 Posts: 108 Topics: 31 Location: USA
|
Posted: Mon Jul 18, 2005 10:26 am Post subject: |
|
|
You can not find the count in the DB2 catalogue tables. But your DBA would be able to tell you for any changes to the tables including counts using log files. |
|
Back to top |
|
|
|
|