MVSFORUMS.com

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

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

schintala · 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.

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

HI

I want to know whether we can find from SYSIBM tables.

nadh

schintala · 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.