MQSeries.net :: View topic - Using ESQL how do we convert an XML message to copybook form

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 » Using ESQL how do we convert an XML message to copybook form

Using ESQL how do we convert an XML message to copybook form

« View previous topic :: View next topic »

Author

Message

upender

Posted: Tue Mar 04, 2014 4:13 am Post subject: Using ESQL how do we convert an XML message to copybook form

Novice

Joined: 04 Mar 2014
Posts: 21

Using ESQL how do we convert an XML message to copybook format
without changing or editing the message itself?

mqjeff

Posted: Tue Mar 04, 2014 5:29 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

By writing ESQL code.

kimbert

Posted: Tue Mar 04, 2014 6:01 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Model the message using MRM CWF ( if on v7 ) or DFDL ( if on v8 or v9 ).
The conversion is usually one line of ESQL ( or any other transformation language ).
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.

mqsiuser

Posted: Tue Mar 04, 2014 7:23 am Post subject: Re: Using ESQL how do we convert an XML message to copybook

Yatiri

Joined: 15 Apr 2008
Posts: 637
Location: Germany

upender wrote:

Using ESQL how do we convert an XML message to copybook format
without changing or editing the message itself?

You have to distinguish between the msg tree structure and (if you need that) the flat file structure

You get XML IN (thats a tree, great!) and with ESQL you convert into another ((logical) type) tree.

With the msg-set you finally write the (target/out) tree (which resembles your out-structure) into a flat file ...
... or you just use XMLNSC (if you want to output XML) and you then do not require a msg set, which can be a big relieve!

If you really need the flat file cobol copybook format... well I don't know if I wanted to create a msg set for that or I'd try to get it from somewhere (support pack or equivalent).
_________________
Just use REFERENCEs

fatherjack

Posted: Tue Mar 04, 2014 2:33 pm Post subject:

Knight

Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island

I thought we didn't answer certification questions here!
_________________
Never let the facts get in the way of a good theory.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Using ESQL how do we convert an XML message to copybook form

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