MQSeries.net :: View topic - Repeat Reference issue

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 » Repeat Reference issue

Repeat Reference issue

« View previous topic :: View next topic »

Author

Message

yellowbee

Posted: Fri May 04, 2012 3:27 am Post subject: Repeat Reference issue

Acolyte

Joined: 14 Apr 2012
Posts: 58

Hi all
this is regarding Repeat reference,
In the message deffinition file, message elements are NO,NAME.
NAME will repeat reference to No.

the ESQL code is

Code:

CALL CopyMessageHeaders();

SET OutputRoot.Properties.MessageSet ='ARMAMOO002001';
SET OutputRoot.Properties.MessageType ='RESULT';
SET OutputRoot.Properties.MessageFormat ='XML1';

DECLARE no,count INTEGER;
SET no =InputRoot.MRM.NO;
SET count =1;
WHILE (count <= no) DO
CREATE OutputRoot.XML.RESULT.DATA.NO[count]= count;
SET OutputRoot.XML.RESULT.DATA.NAME[count]=InputRoot.MRM.NAME[count];

As per the code is the

Quote:

INPUT MESSAGE:-2AABBCCDD
OUTPUT MESSAGE:-<RESULT><NO>1</NO><NO>2</NO><NAME>AABB</NAME><NAME>CCDD</NAME><RESULT>

What are the changes i have to do if the out put message should be as

Quote:

Thank you

yellowbee

Posted: Fri May 04, 2012 3:29 am Post subject:

Acolyte

Joined: 14 Apr 2012
Posts: 58

I tried this but could not get the desired output

Quote:

CREATE FIRSTCHILD OF OutputRoot.XML.RESULT.DATA Domain('MRM') NAME 'NO' VALUE 'count';
CREATE LASTCHILD OF OutputRoot.XML.RESULT.DATA Domain('MRM') NAME 'NAME' VALUE 'InputRoot.MRM.NAME[count]';

kimbert

Posted: Fri May 04, 2012 4:16 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Why is your flow using the deprecated XML domain?

Your problem is probably nothing to do with the message set - the parsing seems to have worked OK. You now have a message tree in InputRoot.MRM. You need to create a different message tree under OutputRoot.XMLNSC.

Your next steps should be:
- Switch to XMLNSC
- Put in Trace nodes so that you can see the structure of the message tree
- Take a user trace so that you can see what your ESQL is actually doing to that message tree.
- Say 'ah, of course. Now I see what is wrong with my ESQL!'
- Fix the problem

gecs

Posted: Fri May 04, 2012 9:23 am Post subject:

Acolyte

Joined: 14 Nov 2007
Posts: 58

Â¿Could you put the structure of the input message tree (MRM domain)?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Repeat Reference issue

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