View previous topic :: View next topic
|
Author |
Message |
mohanrao
New User
Joined: 11 Jun 2005 Posts: 13 Location: bangalore
|
|
|
|
Hello Everyone,
can you please let me how to count the number of rows that got deleted from a db2 table.
I tried using count(*) and moved that to a host vairable.
Apart from the above way is there any other option to achieve the same.
Thanks in Advance,
Mohan |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Mohan,
Welcome to the forum.
I suggest you to search into the forun before starting new topic.By the way you can get the data from SQLERRD(3) which contains the number of rows affected by the embedded data change statement |
|
Back to top |
|
|
mohanrao
New User
Joined: 11 Jun 2005 Posts: 13 Location: bangalore
|
|
|
|
Hi,
Sorry to one n all if I have posted a question which was discussed earlier.
Actually this is DYL-280 requirement wherein it requires to display a count of the number of rows deleted .
Regards,
Mohan |
|
Back to top |
|
|
bhairon singh rathore
New User
Joined: 19 Jun 2008 Posts: 91 Location: banglore
|
|
|
|
Hi Mohan,
Use SQLERRD(3) from SQLCA after delete to Display number of rows affected as clearly stated by Ekta in his previous post. |
|
Back to top |
|
|
mohanrao
New User
Joined: 11 Jun 2005 Posts: 13 Location: bangalore
|
|
|
|
Hi All,
Thanks for your replies. I completely agree that options suggested by forum works perfectly well for a normal cobol-db2 program.
But as per requirement it is a DYL-280 program and hence SQLERR(3) wont work.
Please correct me if Iam wrong.
Regards,
Mohan |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
What does the documentation suggest? Possibly there is something internal to the product where this can be retrieved?
You might open an issue with CA Support and ask what options are available. If i remenber correctly, this is now called CA-Vision. . . |
|
Back to top |
|
|
|