is there any quick way to get affected row count from every branch ofMERGE?

#1

if I'm using the MERGE and want to return how many rows are updated
and how many rows are inserted, the way of get-diagnotics/select-
changed-table doesn't work. A direct way is just to split the
statement to update and insert, return the affected count. or just
use merge, and use the predicate to test the affected count.

is there any good way to do that? or Merge just not a good choice
here?

Thanks.

#2

On 8/10/2010 3:18 AM, Hardy wrote:

Quote:

if I'm using the MERGE and want to return how many rows are updated
and how many rows are inserted, the way of get-diagnotics/select-
changed-table doesn't work. A direct way is just to split the
statement to update and insert, return the affected count. or just
use merge, and use the predicate to test the affected count.

is there any good way to do that? or Merge just not a good choice
here?

Thanks.
Are you saying you want the "ratio" of INSERT vs UPDATE vs DELETE?

I can't think of any easy way. That's where SELECT FROM MERGE would come
in handy....some day,...

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

#3

On Aug 10, 1:15*am, Serge Rielau <srie... (AT) ca (DOT) ibm.com> wrote:

Quote:

On 8/10/2010 3:18 AM, Hardy wrote:> if I'm using the MERGE and want to return how many rows are updated
and how many rows are inserted, the way of get-diagnotics/select-
changed-table doesn't work. *A direct way is just to split the
statement to update and insert, return the affected count. *or just
use merge, and use the predicate to test the affected count.

is there any good way to do that? or Merge just not a good choice
here?

Thanks.

Are you saying you want the "ratio" of INSERT vs UPDATE vs DELETE?
I can't think of any easy way. That's where SELECT FROM MERGE would come
in handy....some day,...

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

Thank you, Serge

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

is there any quick way to get affected row count from every branch ofMERGE?

comp.databases.ibm-db2 comp.databases.ibm-db2

is there any quick way to get affected row count from every branch ofMERGE? - 08-09-2010 , 02:18 PM

Re: is there any quick way to get affected row count from every branchof MERGE? - 08-10-2010 , 01:15 AM

Re: is there any quick way to get affected row count from everybranch of MERGE? - 08-10-2010 , 07:56 AM