Question
Capgemini
IN
Last activity: 14 Jan 2016 17:58 EST
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
PEG
IN
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}
Capgemini
IN
This page only hold the status and pre post sql query. Does not hold the no of record updated. Am I missing something?
Pegasystems
US
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
Capgemini
IN
Yeah. Thats a easy way out and I also followed that in my requirement. But just wanted to do it in a single step.