MQSeries.net :: View topic

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 Code

ESQL Code

« View previous topic :: View next topic »

Author

Message

dsmq

Posted: Fri Jul 26, 2002 4:35 am Post subject: ESQL Code

Acolyte

Joined: 20 Jun 2002
Posts: 59

Hi

My input message is XML that is something like this

<t1>cc</t1><t2>vv</t2><t3>yyy</t3>

I have to get my out put message as following way.

Cc\vv\yyy where \ is the delimiter

Can any body suggest me the ESQL code for this especially for delimiter.

Thanks

AlexeiSkate

Posted: Fri Jul 26, 2002 5:45 am Post subject:

Centurion

Joined: 10 Apr 2002
Posts: 123

dsmg,

I don't know the exact format of your output msg, but if I was to extract the three fields and put it out to a temporary variable in a format that you specified, then I would do something like the following:

DECLARE temp CHAR;
SET temp = InputRoot.XML.t1 || '\' || InputRoot.XML.t2 || '\' || InputRoot.XML.t3;

So maybe in your output msg, you can do something similar like
SET OutputRoot.XML.OutMsg = InputRoot.XML.t1 .....

Hopes that help.

- Alex

dsmq

Posted: Fri Jul 26, 2002 7:29 am Post subject: ESQL Code

Acolyte

Joined: 20 Jun 2002
Posts: 59

Alex

Thanks for your reply

My output message looks like this , it contains the header and fields (basicaly it is in IMF message format).

RES09877665 6778899 ooooooo / SCR502 \ / PUL JFK \ / 1000 \ @

Header :- RES09877665 6778899 ooooooo
fields:- / SCR502 \ / PUL JFK \ / 1000 \ @

\ is the fiels delimiter
/ field identifier and @ end of message (HEX '03' )

Thanks

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL Code

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