Question
4
Replies
365
Views
Capgemini
Posted: January 14, 2016
Last activity: January 14, 2016
Closed
How to find the number of record updated by RDB-Save.
Hi,
How can I get the no of record updated by rdb-save operation. I can see the number in DB-Trace but it does not seems to stored in any parameter. Can any one help me on this?
Thanks,
Saikat
Posted: 5 years ago
This page only hold the status and pre post sql query. Does not hold the no of record updated. Am I missing something?
Posted: 5 years ago
How about preceding your rdb-save with an rdb-query (or executeRDB api call) that does a "select count(*) . . .", using the SAME "where" clause on the "select count(*)" that you use on the subsequent rdb-save ? /Eric
Posted: 5 years ago
Yeah. Thats a easy way out and I also followed that in my requirement. But just wanted to do it in a single step.
One way is:
Add a line above your SQL as the fitst line of your SQL as sbown below. You can name the page anything meaningful. This page will be viewed in the Clipboard that will have both pre and post SQL it executed.
{SQLpage:MySQLPage}