Author |
Message
|
wmb61_user |
Posted: Tue Jun 17, 2008 11:05 am Post subject: Help with creating an e-mail message body. |
|
|
Novice
Joined: 08 May 2008 Posts: 18
|
Folks,
We intend to send out an e-mail with the name of the source queue and the execption message in the body of the e-mail. We have figured out the part where we can send an e-mail with the source queue name. I am stuck as to how to get the exceptionl list in the body along with the queue name. I guess I need to do concatenation but not sure of the correct data types. Any help is appreciated.
Thanks. |
|
Back to top |
|
 |
Gemz |
Posted: Wed Jun 18, 2008 1:21 am Post subject: |
|
|
 Centurion
Joined: 14 Jan 2008 Posts: 124
|
Hi,
Hope you are using MB v6.1
You can concatenate both Queue name and Exception list as a single string and pass it to email node.
Quote: |
SET OutputRoot.XMLNSC.MailMsg = Queuename || ExceptionList; |
|
|
Back to top |
|
 |
AkankshA |
Posted: Wed Jun 18, 2008 1:31 am Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
wont he need to first convert exception list into a string.... may be by using ASBITSTREAM.... since concat operator expects string datatype and results string as well... _________________ Cheers |
|
Back to top |
|
 |
Gemz |
Posted: Wed Jun 18, 2008 2:06 am Post subject: |
|
|
 Centurion
Joined: 14 Jan 2008 Posts: 124
|
Yep ExceptionList has to be string.
He can convert the ExceptionList to string by using ASBITSTREAM or can save the ExceptionList in Env variable and use it. |
|
Back to top |
|
 |
wmb61_user |
Posted: Tue Jul 15, 2008 11:06 am Post subject: Help with creating an e-mail message body |
|
|
Novice
Joined: 08 May 2008 Posts: 18
|
I tried the following and it does not work. Any ideas?.
SET Exceptions = ASBITSTREAM(InputRoot.ExceptionList);
SET OutputRoot.XMLNSC.Email.Body = InputRoot.MQMD.SourceQueue || CAST(Exceptions AS CHARACTER); |
|
Back to top |
|
 |
AkankshA |
Posted: Tue Jul 15, 2008 8:50 pm Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
|
Back to top |
|
 |
wmb61_user |
Posted: Thu Jul 24, 2008 1:32 pm Post subject: |
|
|
Novice
Joined: 08 May 2008 Posts: 18
|
AkankshA,
I am not sure as to what parameters to use in the ASBITSTREAM funciton. Need some guidance.
Thanks. |
|
Back to top |
|
 |
kimbert |
Posted: Thu Jul 24, 2008 1:46 pm Post subject: |
|
|
 Jedi Council
Joined: 29 Jul 2003 Posts: 5542 Location: Southampton
|
The search button will turn up dozens of examples. |
|
Back to top |
|
 |
AkankshA |
Posted: Thu Jul 24, 2008 8:13 pm Post subject: |
|
|
 Grand Master
Joined: 12 Jan 2006 Posts: 1494 Location: Singapore
|
|
Back to top |
|
 |
|