ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Update statement Count

Post new topic  Reply to topic
 Update statement Count « View previous topic :: View next topic » 
Author Message
jlalbor
PostPosted: Tue Oct 11, 2005 3:19 pm    Post subject: Update statement Count Reply with quote

Apprentice

Joined: 18 Feb 2003
Posts: 38

Hi,

we are using Message Broker V5 CSD 5 with DB2 8.1

We have the need to count how many rows where updated with an Update Statement. Is there an indicator like the SQLCODE that has the count of the rows updated with a query?

Thanks.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Oct 11, 2005 3:28 pm    Post subject: Re: Update statement Count Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

jlalbor wrote:
Hi,

we are using Message Broker V5 CSD 5 with DB2 8.1

We have the need to count how many rows where updated with an Update Statement. Is there an indicator like the SQLCODE that has the count of the rows updated with a query?

Thanks.


Not like SQLCODE.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
rmurillo
PostPosted: Tue Jan 22, 2008 8:40 am    Post subject: Re: Update statement Count Reply with quote

Newbie

Joined: 24 Mar 2006
Posts: 5

jefflowrey wrote:
jlalbor wrote:
Hi,

we are using Message Broker V5 CSD 5 with DB2 8.1

We have the need to count how many rows where updated with an Update Statement. Is there an indicator like the SQLCODE that has the count of the rows updated with a query?

Thanks.


Not like SQLCODE.


Say Jeff - that link has become broken. I've been banging my head against this same question all day - can you summarize or repost a link?

Thanks!
Bob
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Jan 22, 2008 8:47 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

http://publib.boulder.ibm.com/infocenter/wbihelp/v6rxmx/index.jsp
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
rmurillo
PostPosted: Tue Jan 22, 2008 9:27 am    Post subject: Reply with quote

Newbie

Joined: 24 Mar 2006
Posts: 5

jefflowrey wrote:
http://publib.boulder.ibm.com/infocenter/wbihelp/v6rxmx/index.jsp


Oh snap! Well, I have indeed been poring over the documentation (SQLCODE, etc.), and nothing stands out. I think I've read the "Capturing database state" page about 7 times now.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Jan 22, 2008 9:32 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

I guess it's a question of A+B...

http://publib.boulder.ibm.com/infocenter/wbihelp/v6rxmx/index.jsp?topic=/com.ibm.etools.mft.fp8.doc/ak05850_.htm

Is the page I must have originally linked to.

I can't possibly construct my thinking at the time, except perhaps I was indicating that the function to use was not named something LIKE "SQLCODE", it was named exactly SQLCODE.

I've no idea if SQLCODE tells you how many rows were updated. I kind of assume that this is going to be database specific, and not a broker generic thing.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
rmurillo
PostPosted: Tue Jan 22, 2008 12:37 pm    Post subject: Reply with quote

Newbie

Joined: 24 Mar 2006
Posts: 5

jefflowrey wrote:
I guess it's a question of A+B...

http://publib.boulder.ibm.com/infocenter/wbihelp/v6rxmx/index.jsp?topic=/com.ibm.etools.mft.fp8.doc/ak05850_.htm

Is the page I must have originally linked to.

I can't possibly construct my thinking at the time, except perhaps I was indicating that the function to use was not named something LIKE "SQLCODE", it was named exactly SQLCODE.

I've no idea if SQLCODE tells you how many rows were updated. I kind of assume that this is going to be database specific, and not a broker generic thing.


Ok thank you Jeff. SQLCODE doesn't tell how many rows are updated. It just returns 100 if no rows were updated, 0 otherwise. I can't find any way at all to get the number I need after much wheel spinning and fruitless experimentation, so I am going to do what I can with "yes or no" rather than "how many".
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Jan 22, 2008 12:48 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

At least on some databases, the return value from Update is equal to the number of rows updated.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
mgk
PostPosted: Tue Jan 22, 2008 2:33 pm    Post subject: Reply with quote

Padawan

Joined: 31 Jul 2003
Posts: 1642

Hi.

At present WMB does not report the number of rows updated as a result of performing an UPDATE against any database type. If you need this functionality you could either use a stored procedure to do the update and return the number or rows updated to WMB via an OUT parameter or you could try raising a requirement through your IBM rep' for this functionality to be considered for a future release.

Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Update statement Count
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.