ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » What is the esql syntax for adding an attribute?

Post new topic  Reply to topic
 What is the esql syntax for adding an attribute? « View previous topic :: View next topic » 
Author Message
edtguy
PostPosted: Thu Nov 11, 2004 10:59 am    Post subject: What is the esql syntax for adding an attribute? Reply with quote

Novice

Joined: 28 Oct 2004
Posts: 13
Location: Hoboken, NJ, USA

Hi,

I cannot seem to get the syntax correct in a compute node to populate an attribute. I need to transform values in an input message to the format of the output message, which includes attributes and an element body. The element body is supposed to be a CDATA structure. I am able to construct the element with a body, but not the attributes.

Here is the statement that sets the body of the element:

Code:
SET OutputRoot.XML.Message."EncodingBase64" = '<![CDATA['||InputRoot.MRM.Attachments.File.content||']]>';


I have tried both of the following approaches for the attributes, but neither seem to work:

Code:
CREATE FIELD OutputRoot.XML.Message."EncodingBase64".Name TYPE NameValue VALUE InputRoot.MRM.Attachments.File.(XML.attr)aFileName;
CREATE FIELD OutputRoot.XML.Message."EncodingBase64".ContentType TYPE NameValue VALUE InputRoot.MRM.Attachments.File.Minetype.aType||'/'||InputRoot.MRM.Attachments.File.Minetype.aSubtype;


or:

Code:
SET OutputRoot.XML.Message."EncodingBase64".(XML.attr)Name = InputRoot.MRM.Attachments.File.(XML.attr)aFileName;
SET OutputRoot.XML.Message."EncodingBase64".(XML.attr)ContentType = InputRoot.MRM.Attachments.File.Minetype.aType||'/'||InputRoot.MRM.Attachments.File.Minetype.aSubtype;


Once again, IBM's documentation is not proving to be of much help.
Does anyone know the correct syntax?

Regards,
Ed
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
jefflowrey
PostPosted: Thu Nov 11, 2004 11:11 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

How do you know these don't work?

What results do they produce?
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
kirani
PostPosted: Thu Nov 11, 2004 12:06 pm    Post subject: Reply with quote

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

Also, please post your Environment details. What is your input message format? XML or MRM-XML or something else?
_________________
Kiran


IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Back to top
View user's profile Send private message Visit poster's website
edtguy
PostPosted: Thu Nov 11, 2004 12:43 pm    Post subject: Reply with quote

Novice

Joined: 28 Oct 2004
Posts: 13
Location: Hoboken, NJ, USA

They don't work because nothing appears in the debug panel for the Output message attribute. When I fully expand the debug message, I am able to see MRM -> Attachments -> File -> aFileName = 'certificate.pdf'
When either statement is executed for the attribute, and I fully expand OutputRoot, I am able to see XML -> Message -> EncodingBase64 -> {unnamed}, where the unnamed node has the base64 encoded contents. There is no Name node under EncodingBase64. I also tried assigning a literal value to the attribute, but that didn't work either.

The input message format is MRM. I'm not sure what you mean by "Environment Details".
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » What is the esql syntax for adding an attribute?
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.