| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SHARED ROW Variable - To update/delete |
« View previous topic :: View next topic » |
| Author |
Message
|
| wmb_wps_soa |
 Posted: Wed Dec 17, 2014 11:37 am Post subject: SHARED ROW Variable - To update/delete |
 |
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Hi All,
Can we update OR delete the data that is in SHARED ROW variable list? I know, I can make the SHARED ROW empty and reload it, but my requirement is not to empty the whole SHARED ROW, but to update a counter in the SHARED list based on the input data. Is it possible?
Thanks
SJ |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Dec 17, 2014 11:38 am Post subject: Re: SHARED ROW Variable - To update/delete |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wmb_wps_soa wrote: |
| Can we update OR delete the data that is in SHARED ROW variable list? |
In the same way and with the same restrictions as with a ROW variable that isn't shared, with the added wrinkle you potentially will need to deal with multiple threads accessing the variable.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wmb_wps_soa |
| Posted: Wed Dec 17, 2014 11:57 am Post subject: |
|
|
Acolyte
Joined: 19 Feb 2010
Posts: 65
Location: Detroit,Michigan,USA.
|
Thanks Vitor.
I am making the flow as a single threaded flow. As there is no way to update the data in SHARED ROW using a single statement, I tried to use looping to update counter in the matching occurrence, however this is the error that I get "Attempt to obtain both a write and a read lock". |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Dec 17, 2014 12:02 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wmb_wps_soa wrote: |
| As there is no way to update the data in SHARED ROW using a single statement |
Oh. That's a shame. You'd have thought IBM would have thought of that.
| wmb_wps_soa wrote: |
| I tried to use looping to update counter in the matching occurrence, however this is the error that I get "Attempt to obtain both a write and a read lock". |
Yep, you would have.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
