| Author |
Message
|
| apple_guy |
 Posted: Thu Oct 06, 2011 8:08 am Post subject: Need help using emailoutput node |
 |
|
Newbie
Joined: 06 Oct 2011
Posts: 3
|
Hello, I am new to message broker but I am familiar with it. I am stuck in a task I have received.
My aim is to gather data and email addresses from a database and send that specific data to that email address.
For this I’m using a ‘compute’ node to gather a list of email address and their names from a table. Then using their names as a parameter, gathering data from database using stored procedure. Then ‘propagating’ this data to an ‘XSL Transform’ node. From there I am sending it to another compute node where I am setting email parameters before sending it to emailoutput node. (looping this process for each emailaddress and name in the first table)
The problem is I am not able to find a way to send the email address from first compute node to the 2nd compute node as there is a XSL transformation in between. I am gathering the data from the stored procedure using dynamic result set and saving it in XMLNSC format before sending it to Transformation, my email address is in a variable. So how can I send this variable to second compute node along with its data from XML Transformation? Please recommend a solution.
If my query is not clear, then please say so. I will post my flow and code.
Thanks in advance. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Oct 06, 2011 8:10 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Store data in LocalEnvironment variables tree.
Have you taken the WM663 class? If not, why not?
This information is covered in that class.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Oct 06, 2011 8:11 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| If you are familiar with Broker development, then it is common to use either Environment or LocalEnvironment to pass data between nodes. |
|
| Back to top |
|
|
| apple_guy |
| Posted: Thu Oct 06, 2011 8:44 am Post subject: |
|
|
Newbie
Joined: 06 Oct 2011
Posts: 3
|
Thanks for your replies.Appreciate any help.
If I use LocalEnvironment variables then wouldn't the value be overwritten with the next email address while the data to be mailed is still in process. I mean wouldn't wrong data be sent to a wrong email address. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Oct 06, 2011 8:48 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| I don't see how you could code your flow to cause that. |
|
| Back to top |
|
|
| apple_guy |
| Posted: Thu Oct 06, 2011 8:52 am Post subject: |
|
|
Newbie
Joined: 06 Oct 2011
Posts: 3
|
Thanks, I will try it out.
@lancelotlinc No I haven't received any formal training. My seniors are guiding me until my training is scheduled. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Thu Oct 06, 2011 8:56 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| apple_guy wrote: |
Thanks, I will try it out.
@lancelotlinc No I haven't received any formal training. My seniors are guiding me until my training is scheduled. |
I would suggest you not develop any production flows until you have had the training. You are missing some crucial, basic information that will jeapordize a production environment.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Oct 06, 2011 8:56 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Ask your seniors to explain how message flow nodes are processed. |
|
| Back to top |
|
|
|
|
