| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| GDM Updates 2 tables and I want to add the updatedRows... |
« View previous topic :: View next topic » |
| Author |
Message
|
| JosephGramig |
 Posted: Thu Jul 16, 2015 9:04 am Post subject: GDM Updates 2 tables and I want to add the updatedRows... |
 |
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
I'm using the GDM to update two tables and build one SOAP response. It all works, but what I cannot figure out is how to add the NumberOfRowsUpdated in the Return part and assign that to a field in the SOAP response.
Anybody doing that?
I'm sure the answer is simple, once you know it.
MQ 7.5.0.4, IIB 9.0.0.3, zLinux |
|
| Back to top |
|
 |
| martinb |
| Posted: Fri Jul 17, 2015 10:50 pm Post subject: |
|
|
Master
Joined: 09 Nov 2006
Posts: 210
Location: UK
|
Hi Joseph
Each of your Update transforms has a Return part in the transform group.
The predefined input inside the nested mapping of the Return is "NumberOfRowsUpdated".
If you have two separate elements in your response message you can simply wire the output of each of your two Update Returns to the relevant element.
However maybe what you actually need is a single response element to be set to the sum of these?
That is still achievable. While you cannot wire the output of the two Return's into an additional Transform step that summed them, the answer is to nest of chain the Updates.
So in your Map you'd do one of the Update transforms. On the Return of that first Update wire the output to the whole SOAP Response, and wire all the data you need from the SOAP Request into this Return as well.
Next inside the nested mapping of the first Update,you add the second Update. Now in for the Return of the second Update you can wire the First Update's "NumberOfRowsUpdated" into the second's Return, and connect it's output to your single element that wants the sum of rows updated.
HTH |
|
| 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
|
|
|
|
