MQSeries.net :: View topic - ESQL-Select: XML attributes are lost after SELECT statement

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL-Select: XML attributes are lost after SELECT statement

ESQL-Select: XML attributes are lost after SELECT statement

« View previous topic :: View next topic »

Author

Message

birger.r

Posted: Wed Jan 22, 2014 12:50 pm Post subject: ESQL-Select: XML attributes are lost after SELECT statement

Novice

Joined: 22 Jun 2010
Posts: 10

Hi all,

I am trying to run this code against a MRM-parsed message:

Code:

SET Environment.ship_to[] = SELECT * FROM rInHeader.PARTY_ID_DETAILS[] AS st WHERE st.identification_of_name = 'ST';

SET rOutHeader.customerNumber = Environment.ship_to[1].identification_code; -- retruns a number => correct
SET rOutHeader.customerGroup = Environment.ship_to[1].identification_code.type_of_identification_code; => returns NULL, but a string should be there

type_of_identification_code is an XML attribute.

When debugging my code, I can see the XML attribute in the message tree of the incoming message, but it is not getting copied to the environment when running the code listed above.

I am on WMB 7 FP3.

I am lost...

Birger.

fjb_saper

Posted: Wed Jan 22, 2014 1:01 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

When you park stuff in the Environment you first need to specify the relevant PARSER. The environment has no default parser set.

_________________
MQ & Broker admin

birger.r

Posted: Wed Jan 22, 2014 1:25 pm Post subject:

Novice

Joined: 22 Jun 2010
Posts: 10

Yay. Doing it right helps from time to time. (I never had this issue ever before and I am copying a lot of stuff to the Environment (with attributes)...)

Thanks a lot. :thumbup:

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL-Select: XML attributes are lost after SELECT statement

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