|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
Datatype of Email.Attachment.Content? |
« View previous topic :: View next topic » |
Author |
Message
|
ram_svnit |
Posted: Tue Oct 06, 2009 4:51 am Post subject: Datatype of Email.Attachment.Content? |
|
|
Novice
Joined: 28 Aug 2009 Posts: 20 Location: India
|
Hi, I need to conevrt an XML message to CSV and send it as an email attachment. I wrote the following code
SET OutputRoot = InputRoot;
SET OutputRoot.Properties.MessageFormat='CSV';
SET OutputLocalEnvironment.Destination.Email.SMTPServer='10.94.68.90';
SET OutputLocalEnvironment.Destination.Email.Attachment.Content= CAST(OutputRoot.MRM as BLOB);
The last line does not work. I debugged it, the 'Content' is not created.
Please help me on this. |
|
Back to top |
|
 |
mgk |
Posted: Tue Oct 06, 2009 5:07 am Post subject: |
|
|
 Padawan
Joined: 31 Jul 2003 Posts: 1642
|
Quote: |
I debugged it, the 'Content' is not created. |
That's because the CAST returned NULL. Look at the ASBITSTREAM function instead of the CAST in this case. This is because CAST only CASTs a single field to the target type, whereas you are trying to turn a whole tree into a BLOB and that's a job for ASBITSTREAM...
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 |
|
 |
ram_svnit |
Posted: Wed Oct 07, 2009 3:57 am Post subject: |
|
|
Novice
Joined: 28 Aug 2009 Posts: 20 Location: India
|
I tried with ASBTSTREAM(OutputRoot.MRM)
That gives an error-Invalid wire format. ASBITSTREAM(OutputRoot) works.But i want only message body. |
|
Back to top |
|
 |
kimbert |
Posted: Wed Oct 07, 2009 2:18 pm Post subject: |
|
|
 Jedi Council
Joined: 29 Jul 2003 Posts: 5542 Location: Southampton
|
Quote: |
I tried with ASBTSTREAM(OutputRoot.MRM) |
- The product documentation accurately describes how to use ASBITSTREAM
- There are several examples of correct usage in the documentation
- There are many examples of correct usage in this forum ( use the search button ). |
|
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
|
|
|
|